Full Name:

$(\frac{60}{9})$

Date:

MIS $4163$ Chapter $4$ Case Study

Study the E$-$R diagram in Figure $8\mathrm{.}23.$ Based on this E$-$R diagram, answer the following questions:

a$.$ How many PROJECTs can an employee work on$?$

b$.$ How many TASKs can an employee work on$?$

c$.$ Do you think EMPLOYEE entity has relationship to TASK entity?

d$.$ What is the type of the Includes relationship?

e$.$ 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?