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

Explanation & Answer

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.