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...

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).