Task Normalisation 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 Rationale This assessment item is designed to test your understanding of the normalisation process based on existing data in order to minimise redundancies and data anomalies.