Objectives To develop an ER diagram from a provided scenario To create normalised relations of the data To create a Database Schema The entities and relationships are in third normal form, unless...

Objectives

To develop an ER diagram from a provided scenario

To create normalised relations of the data

To create a Database Schema

The entities and relationships are in third normal form, unless valid reasons given
Assumptions must be given if business rules are ambiguous or unclear