Study the E-R diagram in Figure 8.23. 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 the Includes relationship?

c. Are there any associative entities on this diagram? If so, name them.

d. How else could the attribute Skill be modeled?

e. Is it possible to attach any attributes to the Includes relationship?

f. Could TASK be modeled as an associative entity?

g. Employees’ 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?

Figure 8.23

Transcribed Image Text:

PROJECT EMPLOYEE Works on Project ID Employee_ID Includes 太 TASK Used on Done_at Task ID Time %23 TOOL CITY {Skill}