Database System Design and Management - ERD

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.