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;