Use the following business rules to create a Crow’s Foot Entity Relationship Diagram. Write all appropriate connectivities and cardinalities in the ERD. Add other linking entities as needed. • A department employs many employees, but each employee is employed by one department. • Some employees, known as “rovers,” are not assigned to any department. • A division operates many departments, but each department is operated by 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.
Use the following business rules to create a Crow’s Foot Entity Relationship Diagram. Write all appropriate connectivities and cardinalities in the ERD. Add other linking entities as needed.
• A department employs many employees, but each employee is employed by one department.
• Some employees, known as “rovers,” are not assigned to any department.
• A division operates many departments, but each department is operated by 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.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images
