Assessment item 3 Normalisation 1

Value : 13%

Submission method options : Alternative submission method

Task

Using above table

Draw a dependency diagram to show the functional dependencies in the relation Decompose the relation into a set of 3NF relations Draw a relational schema for your 3NF relations and show the referential integrity constraints Create an ERD that represents your 3NF relations

NOTE

For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video : www.youtube.com
Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema or the ERD is NOT acceptable.

Rationale

This assessment aligns with the following subject outcomes: be able to critically analyse a database design and apply normalisation theory and techniques;

To Download Click Here > Assessment item 3 Normalisation 1.pdf