Assignment: Modelling & Normalisation
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. 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
|