Database Design & Development
COIT20247 Database Design and Development (T2 2019) Assessment item 2—Assignment 2 Objectives This assessment item relates to the unit learning outcomes numbers 1, 2 and 3 as stated in the unit profile. Part A. Database implementation using MS Access Introduction The sample solution of assignment 1 will be released on the unit 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 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 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).