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 E-R diagram given below. Based on this E-R 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 E-R diagram would you represent the new
attribute Hourly pay rate?
 Study the E-R diagram given below. Based on this E-R diagram,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!