ICT214-AdvancedDatabase-Assessment-01-11.docx
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.