A. You have to map the ERD diagram, into a set of relations in at least 3rd normal form. You must make sure that your relation meets third normal form.
B. You have to select any two of your relations from the previous step and perform the following for each of those two relations:
a. List all the functional dependencies exist in the relation
b. Demonstrate that the relation meets third normal form
[googlepdf url=”https://assignmentquestion4me.com/wp-content/uploads/2018/02/COIT20247-Database-Design-and-Development-Database.pdf” width=”100%” height=”400″ ]