Objectives  To develop an ER diagram from a provided scenario  To create normalised relations of the data  To create a Database Schema The following course learning outcomes are assessed by...

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