Question: 1. Study the ER diagram shown below. Based on this E-R diagram, answer the following questions and, in each case, give reasons and if appropriate,

 1. Study the ER diagram shown below. Based on this E-R

1. Study the ER diagram shown below. Based on this E-R diagram, answer the following questions and, in each case, give reasons and if appropriate, a partial ERD diagram in support of your answer: _ VProiecLlD ' -L : EMPLOYEE] Includes If - "IDOL\" - -' How many PROJECTS can an employee work on?I What is the degree of the \"Includes" relationship (i.e. it's cardinality)? Are there any many-to-many relationships on this diagram? If so, name them. How else could the attribute Skill be modelled? Is it possible to attach any attributes to the \"Works on\" relationship? If so, give an example of a suitable attribute. If not, why? Could TASK be modelled as a relationship? If 50, show how. If not, why? Is it possible to tell which task(s) an employee is working on? If so, how? If not, what changes are required to show this? h. Is it possible to tell which tool(s) are being used on a particular project? If so, how? If not, what changes are required to show this? EDP-.0575\" (07&quot

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 General Management Questions!