Please see attached document and important instructions below:
*The assignment is to be presented as a Word document, however dependency diagrams can be done in any other software (PowerPoint is ok) but need to do a screen shot and place in the Word document - this is needed for each NF level.
*It needs to show 1NF, then 2NF and take it to 3NF.
*It needs to indicate the type of dependencies, and show the normalisation
process as you resolve at each NF.
*You need to produce a final ERD after normalising. This may be done in Workbench, or in any other software.
Using the given table/relation, do the following:
1. Draw a dependency diagram to show the functional dependencies in the relation
2. Decompose the following table into a set of 3NF relations
3. Draw a relational schema for your 3NF relations and show the referential integrity constraints
4. Manually drawing the dependency diagrams is not acceptable.
Trainer_ID Trainer_Name Room_No Room_Seats Class_Session Class_Name Class_Day School
101 Alana Fredrick 54A 36 9:00 ITC114 Mon Computing
102 George Edwards 22 28 9:00 ITC333 Mon Computing
103 Lilly Nelly 59 38 12:30 BUS350 Tues Business
104 Eddy Brown 53 30 12:30 ITC114 Thurs Computing
102 George Edwards 59 38 4:00 ITC504 Fri Computing
103 Lilly Nelly 18 24 12:30 BUS360 Wedn Business
102 George Edwards 53 30 9:00 ITC201 Wedn Computing
105 Sam Wang 22 28 4:00 ITC556 Tues Computing
106 Yifeng Chong 58 38 9:00 ITC556 Thurs Computing