Database design – er diagram and must create a mysql schema for the

Assignment 01: Database Design

Assignment Requirements

Task 1:

Create a Crow’s 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.

image1.gif