Objectives  To develop an ER diagram from a provided scenario  To create normalised relations of the data  To create a Database Schema Timelines and Expectations  Percentage Value of Task: 20% ...

Objectives  To develop an ER diagram from a provided scenario  To create normalised relations of the data  To create a Database Schema
Timelines and Expectations  Percentage Value of Task: 20%  Due: Friday, May 5th 2017, 5.00pm. (Week 7)  Minimum time expectation: 12 hours  The entities and relationships are in third normal form, unless valid reasons given  Assumptions must be given if business rules are ambiguous or unclear
Learning Outcomes Assessed The following course learning outcomes are assessed by completing this assessment:  K4. design a relational database for a provided scenario utilising tools and techniques including ER diagrams, relation models and normalisation  K5. describe relational algebra and its relationship to Structured Query Language (SQL);  A1. design and implement a relational database using a database management system;