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 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"
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
