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







Oct 07, 2019
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here