DATABASE SYSTEM DESIGN AND MANAGEMENT

Assignment 4: ERD
Use the following business rules to create a Crow’s Foot ERD. Write all appropriate connectivity and
cardinalities in the ERD.
 A department employs many employees, but each employee is employed by only one
department.
 Some employees, known as “rovers,” are not assigned to any department.
 A division operates many departments, but each department is operated by only one division.
 An employee may be assigned 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, and each department is managed by only
one employee.
 One of the employees runs each division, and each division is run by only one employee.