Question

Create a complete ERD for the problem described in problem

ch team those cond Identif . Identify . Identif . Identif PLAY . Draw . Draw Part 2 Design Concepts blems 1. 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. 4 Create a . An employee may be assigned many projects, and a project may have many employees assigned to it. . An I invo . A project must have at least one employee assigned to it. . One of the employees manages each department, and each department is man- . The aged by only one employee. have One of the employees runs each division, and each division is run by only one employee. An 2. Create a complete ERD in Crow's Foot notation that can he imnlemented in the Th

Answer 1

A department employs many employees, but each employee is employed by only one department. Works 1 Employee Department for One of the employee manages each department, and each department is managed by only one employee Employee manages Department A division operates many departments, but each department is operated by only one diagram Department Division operate One of the employee runs each division, and each division is run by only one emp loyee Employee Division runs An employee may be assigned many projects, and a project may have many employee assigned to it. Works for Employee Project

I add some compulsory attributes to each entity and use cardinality to relate to entities.

Eno Works first phone no for Dname name Employee Department Dlocation last manages salary ontrols Runs age addres operate works on has Project cat name Division category Pno Pname here category is only to decide the employee category. If employee belongs to "rivers" then it has not any department. Project is controls by department.

In above ER Diagram, I  take some assumptions that are written by points. Each entity has its attributes. I create this ERD simple as mentions in the question so if there is any mistake then, please correct them.