A department employs many employees but each employee is


Question: Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities 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.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: A department employs many employees but each employee is
Reference No:- TGS02324606

Expected delivery within 24 Hours