This assessment item relates to the course learning outcomes numbers 1, 2 and 3 as stated in the course profile. Introduction The sample solution of assignment 1 will be released on the course website...

This assessment item relates to the course learning outcomes numbers 1, 2 and 3 as stated in the course profile.


Introduction
The sample solution of assignment 1 will be released on the course website approximately two (2) weeks after the assignment 1 due date.  You must use that sample solution of assignment 1 only for the following tasks:


Assessment task


1    Normalization
a)    Map the ERD, from the sample solution, into a set of relations in at least Third Normal Form (3NF). You must ensure that your relations meet 3NF. There is no need to show your working.
b)    Select any two (2) of your relations from the previous step, 1a), and perform the following for each of those two relations:
•    List all the functional dependencies exist in the relation.
•    Demonstrate that the relation meets Third Normal Form (3NF).