Objectives: To develop an ER diagram from a provided scenario, To create normalised relations of the data, To create a Database Schema, Learning Outcomes Assessed. The following course learning...

Objectives:
To develop an ER diagram from a provided scenario,
To create normalised relations of the data,
To create a Database Schema,
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;