PPT Slide
1. Use the following business rules to write all appropriate connectivities and cardinalities in an E-R diagram:
- A department employs many employees, but each
employee is employed by one department, although some
employees, known as "rovers", are not assigned to any
- A division operates many departments, but each
department is operated by one division;
- An employee may be assigned to many projects and a
project may have many employees assigned to it;
- A project must have at least one employee assigned to it;
- One of the employees manages each department;
- One of the employees runs each division.