Task: 1. Draw a dependency diagram to show the functional dependencies in the relation 2. Decompose the relation into a set of 3NF relations 3. Draw a relational schema for your 3NF relations and show...

Task:

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

2. Decompose the relation into a set of 3NF relations
3. Draw a relational schema for your 3NF relations and show the referential integrity constraints
4. Create an ERD that represents your 3NF relations


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