Question: Study the E - R diagram given below. Based on this E - R diagram, answer the following questions: a ) How many PROJECTS can
Study the ER diagram given below. Based on this ER diagram, answer the following questions:
a How many PROJECTS can an employee work on
b What is the degree of includes relationship?
c Are there any associative entities on this diagram? If so name them.
d How else could attribute Skill be modelled?
e Could TASK be modelled as an associative entity?
f Employee's earnings are calculated based on a different hourly pay rate for
each project. Where on the ER diagram would you represent the new
attribute Hourly pay rate?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
