Use Microsoft Visio or Draw io to draw the diagram Use IE (crows foot) notation The Department Employee Database (12 points) A department employee database should meet the following business requirements Use the following descriptions to create a Crows foot ERD A division is identified by its division ID Division name is needed A department is identified by its department ID Department name is needed An employee is identified by the employee ID Employees first names and last names are recorded A project is identified by a project ID Data about project name is needed A division operates several departments, and each department is operated by one and only one division One of the employees runs each division, and each division is run by only one employee A department has many employees, and each employee is employed by one (and not more than one) department Some employees do not belong to any department Each department must have one employee as the manager An employee cannot manage more than one department An employee may work on no project or many projects A project at least should have one employee assigned to it and normally may have several employees assigned to it Paste Your Answer Diagram Here

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 02, 2024

Use Microsoft Visio or Draw.io to draw the diagram.

Use IE (crows foot) notation.

The Department-Employee Database (12 points) A department-employee database should meet the following business requirements. Use the following descriptions to create a Crows foot ERD.
- A division is identified by its division ID. Division name is needed. A department is identified by its department ID. Department name is needed. An employee is identified by the employee ID. Employees first names and last names are recorded. A project is identified by a project ID. Data about project name is needed.
- A division operates several departments, and each department is operated by one and only one division. One of the employees runs each division, and each division is run by only one employee.
- A department has many employees, and each employee is employed by one (and not more than one) department. Some employees do not belong to any department. Each department must have one employee as the manager. An employee cannot manage more than one department.
- An employee may work on no project or many projects. A project at least should have one employee assigned to it and normally may have several employees assigned to it.

Paste Your Answer Diagram Here: