DATABASE Design - ER diagram and must create a MySQL schema for the ER diagram.

Assignment 01: Database Design

Due date:	Week 06.
Weighting:	30%
Length and Format:	A word document and SQL file must be submitted
Assessment Details:	Individual Assessment. Student must create an ER diagram. Students must create a MySQL schema for the ER diagram.
Assessment addresses SLOs	A: Utilize the concepts of data (both structured and unstructured), meta-data, information, and knowledge in the development of the organization’s databases or other repositories. B: Model, design and implement complex database structures (including databases distributed over a network) using a relational database management system (RDBMS)
Marking Criteria	Please refer to Marking Rubric on Canvas

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.