ICT214 - DATABASE Design - ER Diagram

DATABASE Design - ER Diagram And Must Create A MySQL Schema For The ER Diagram.

ICT214 - Advanced Database - Assessment

 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