Task Normalisation Using the given table/relation, do the following: 1. Draw a dependency diagram to show the functional dependencies in the relation 2. Decompose the following table into a set of 3NF...

Task

Normalisation

Using the given table/relation, do the following:

1.    Draw a dependency diagram to show the functional dependencies in the relation

2.    Decompose the following table into a set of 3NF relations
3.    Draw a relational schema for your 3NF relations and show the referential integrity constraints. Manually drawing the dependency diagrams is not acceptable.
Rationale
This assessment item is designed to test your understanding of the normalisation process based on existing data in order to minimise redundancies and data anomalies.