Create a Crows Foot ER diagram for the following business Rules. Write all appropriate connectivities and cardinalities in the ERD. Create a data dictionary by adding some attributes to each entity.

• 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.

Task 2: Create an SQL file based on the ER diagram shown below and add a minimum of 3 records for each entity in the database: Submission Requirements Students must submit their assignments through CANVAS shell. Email submissions will not be accepted. Deliverables: A Microsoft Word document containing the ER diagram and the data dictionary to answer Task 1. An SQL file ready to be uploaded to the WAMP server to Task 2.

Attachments:

ICT214-Advanc....docx