Based on this E-R diagram, answer the following questions:
- How many PROJECTs can an employee work on?
- What is the degree of the Includes relationship?
- Are there any associative entities on this diagram? If so, name them.
- How else could the attribute Skill be modeled?
- Is it possible to attach any attributes to the Includes relationship?
- Could TASK be modeled as an associative entity?
- 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?
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"