Consider the following set of requirements for a COMPANY database that is used to keep track of its employees, departments, and projects. An employee can work for only one department; however, a...


Consider the following set of requirements for a COMPANY database that is used to keep track of its employees, departments, and projects.


An employee can work for only one department; however, a department can have any number of employees. A department is managed by only one manager and a manager can manage only one department. A department can control any number of projects; however, one project can be handled by only one department. Any number of employees can work on any number of projects.


                Design an E-R diagram for COMPANY database. Specify the key attributes of each entity type, role names, and mapping cardinalities. Make appropriate assumptions to complete the specifi cation.



Jan 01, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here