Question

In: Computer Science

SUBJECT: DATABASE SYSTEMS !!! Please answer the question as early as possible !!! Question 1 You...

SUBJECT: DATABASE SYSTEMS

!!! Please answer the question as early as possible !!!

Question 1
You are required to draw a complete Crow’s Foot ERD that includes the following entity
relationship components based on the below descriptions:
i) Identify all of the entities and its attributes.
ii) Identify all possible relationships and its connectivity.
iii) Identify the primary key and foreign key for each entity.
iv) Identify the participation constraint and cardinality for each relationship.
A Super5 company contains many departments. Each department has name and is identified
by department code. Each department employs many employees. An employee can work only
in one department. Each employee has ID number, name, job specialization, and email as the
attribute. Not all employees such as president and vice presidents will be assigned a
department.
Manager within the employee may supervises at least fifteen employees under his/her
supervision. An employee can be supervised by only one manage but president and vice
presidents no need manager to supervise them.
Every year Super5 company will organized a fund-raising events to aid an orphanage home.
During the event, a department needs to set up at most three committees and each committee
handled by one and only one department. The committee has committee id and committee
name. But not all departments need to set up a committee.
Each committee will be assigned to do many tasks. A task will be completed by one and only
one committee. The maximum number of tasks per committee is five. Special task will not be
handled by committee. The task will have the task number, task name, assign date, and task
duration to be completed.
There are many employees’ becoming a member of the committee. Each employee can work
in a committee based on the fund-rising event. This event will be held from time to time basis.
Whenever an employee is participating as committee member in fund-raising event,
participation date, event name, and position must be stored. Each event will have a unique
code.

Solutions

Expert Solution

Question i) Identify all of the entities and its attributes.

  • 1) Department entity : Attributes are { Department_code , Department_name}
  • 2) Employee entity : Attributes are { Employee_ID , name ,email ,  job specialization , Department_code, Manager_ID , Committee_ID}
  • 3) Manager entity : Attributes are { Manager_ID , name , email}
  • 4) Committee entity : Attributes are { Committee_ID , Committee_Name}
  • 5) Event entity : Attributes are { Event_code , participation_date , Event_name , position , committee_ID}
  • 6) Task entity : Attributes are { Task_No , Task_Name , assignDate , taskDuration , Committe_ID}

Question ii) Identify all possible relationships and its connectivity.

  1. There are employee relationship between Department entity and Employee entity
  2. There are supervises relationship between Employee entity and Manager entity
  3. There are SetUp relationship between Department entity and Committee entity
  4. There are Member relationship between Employee entity and Committee entity
  5. There are For relationship between Committee entity and Event entity
  6. There are assigned relationship between Committee entity and Task entity

Question iii) Identify the primary key and foreign key for each entity.

PK in the diagram are :

  • Department_code : PK for Department Entity
  • Manager_ID : PK for Manager entity
  • Employee_ID : PK for Employee entity
  • Committee_ID : PK for Committe entity
  • Event_code : PK for Event entity
  • Task_no : PK for Task entity

FK in the diagram are :

  • Department_code : FK in Employee entity and Committee entity
  • Manager_ID : FK in Employee entity
  • Committee_ID : FK in Employee entity , Event entity and Task entity.

Question iv) Identify the cardinality for each relationship.

  1. There are 1:M cardinality between Department entity and Employee entity. Or we can say that there are 1: 0..M multiplicity between them .
  2. There are M:1 cardinality between Employee entity and Manager entity. Or we can say that there are 0..M : 1 multiplicity between them.
  3. There are 1:M cardinality between Department entity and Committee entity. Or we can say that there are 0.1 : 1..3 multiplicity between them .
  4. There are M:1 cardinality between Employee entity and Committee entity. Or we can say that there are 1..M : 1 multiplicity between them.
  5. There are 1:M cardinality between Committee entity and Event entity.Or we can say that there are 1 : 1..M multiplicity between them.
  6. There are 1:M cardinality between Committee entity and Task entity. Or we can say that there are 1 : 1..3 multiplicity between them.

ERD diagram :

Thank you...........


Related Solutions

Please answer these questions in as long of detail as possible. Question 1 a) Write the...
Please answer these questions in as long of detail as possible. Question 1 a) Write the expression used to calculate rate of digestion as it’s related to starch concentration and time: b) Explain what a catalytic process is and how it is different from the non-catalytic version of the process. Give an example of an enzymatic process other than amylase and describe the substrate(s)/product(s): c) Describe what the enzyme amylase does and what would happen in the absence of this...
CAN YOU PLEASE ANSWER AS SOON AS POSSIBLE AND PLEASE ANSWER ALL QUESTIONS THANK YOU 1/...
CAN YOU PLEASE ANSWER AS SOON AS POSSIBLE AND PLEASE ANSWER ALL QUESTIONS THANK YOU 1/ What is one similarity and one difference between voluntary motor system that innervate the head versus voluntary motor system that innervate the body? 2/ Does olfactory bulb (direct) relay to primary sensory cortex via the thalamus? 3/ Write a short paragraph using the following terms: opiates; endorphins, pain relief. 4/ In your own words, explain one way in which neuroplasticity allows learning and memory...
Can you please answer all questions and please answer as soon as possible THANK YOU 1/...
Can you please answer all questions and please answer as soon as possible THANK YOU 1/ what do you think wernicke’s area of an infant develops prior to Broca’s? 2/ Create a short paragraph using the following terms: fovea, cones, rods, peripheral retina, acuity, center of the visual field? 3/ Why cone receptors are able to send information about different frequencies of light? 4/why do you think it is easier to name a taste in food than a smell in...
CAN YOU PLEASE ANSWER AS SOON AS POSSIBLE AND PLEASE ANSWER ALL QUESTIONS THANK YOU 1-...
CAN YOU PLEASE ANSWER AS SOON AS POSSIBLE AND PLEASE ANSWER ALL QUESTIONS THANK YOU 1- What is one similarity and one difference between voluntary motor system that innervate the head versus voluntary motor system that innervate the body? 2- Does olfactory bulb (direct) relay to primary sensory cortex via the thalamus? 3- Write a short paragraph using the following terms: opiates; endorphins, pain relief. 4- In your own words, explain one way in which neuroplasticity allows learning and memory...
CAN YOU PLEASE ANSWER ALL QUESTIONS AND PLEASE ANSWER AS SOON AS POSSIBLE 1. The processing,...
CAN YOU PLEASE ANSWER ALL QUESTIONS AND PLEASE ANSWER AS SOON AS POSSIBLE 1. The processing, where different kinds of information are processed in different brain structures, is called: a. Stream segregation b. Serial processing c. Distributed processing d. Parallel processing 2. In vision, what does dark adaptation mean? a. Decrease in color discrimination that occurs after a period in the dark b. The increased sensitivity of the eye that occurs when being in the dark for a long time...
IT344- Database Management Systems book Fundamentals Of Database Systems please no copy and paste Use your...
IT344- Database Management Systems book Fundamentals Of Database Systems please no copy and paste Use your own words , No handwriting. Users prefer to stream high quality videos (e.g., watch YouTube) without lagging (i.e., slow loading). In this context, explain how UDP is better than TCP when streaming videos?
Can you please answer the question in an excel with the calculation if possible. T&J manufacturing...
Can you please answer the question in an excel with the calculation if possible. T&J manufacturing has a factory that produces custom kitchen cabinets. It has multiple product lines. Materials and labor for the cabinets are determined by each job. To simplify the assignment, we will assume the following average costs. The materials include $1,000 for the wood and other direct materials of $200. Both items listed are on a per job basis. It requires 20 hours of labor on...
Answer the following questions as detailed as possible: Question #1 – Time Value of Money Please...
Answer the following questions as detailed as possible: Question #1 – Time Value of Money Please give an example from your own personal or professional experiences (life/career) that involves the Time Value of Money. The Time Value of Money defined as in Chapter 4 as: Present Value, Future Value, Present Value of an Annuity, Future Value of an Annuity, Amortization. It can be one of these above or multiple. Explain the example and how this/these money valuation tools fit into...
PLEASE ANSWER #8, 9 AND 10 AS SOON AS POSSIBLE. THANK YOU IF POSSIBLE PLEASE DO...
PLEASE ANSWER #8, 9 AND 10 AS SOON AS POSSIBLE. THANK YOU IF POSSIBLE PLEASE DO WHOLE QUESTIONS. I WANT TO DOUBLE CHECK WITH MINE Required:#1.Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx". Use the following accounts as appropriate: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated Depreciation, Accounts Payable, Wages Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Depreciation Expense, Wages Expense, Supplies Expense, Rent...
Note:Subject:Note: my subject is early childhood education. I need the answer of this question.Suppose you have...
Note:Subject:Note: my subject is early childhood education. I need the answer of this question.Suppose you have been working for the past five years in the infant room of your early childhood program. You realize that numerous parents can't understand what their infants are learning. You know that during this time, infants' progress toward developmental milestones in areas of Erikson's theory of Trust and Attachment. Your assignment is to write a letter to the parents of the infants in your class,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT