Database Normalization

Question: Discuss about the Database Normalization Answer: Dependency Diagram The dependency diagram is explaining the dependency in the above table. The fields are dependent on each other in Trainer, Room and Class Session table. There is partial and transitive dependency in between the fields. 3NF Relations (Access Programmers n.d.) Relational Schema Trainer (Trainer_ID, Trainer_Name) Primary Key - Trainer_ID Room (Room_No, Room_Name, School) Primary Key - Room_No Class_Session (Trainer_ID , Room_No, Class_Session, Trainer_Name , Room_Name, Class_Name, Class_Day, School) Primary Key - Trainer_ID, Room_No, Class_Session Trainer_ID references Trainer (Trainer_ID) Room_No references Room (Room_No) (Guru99 2016) ER Diagram References Guru99 2016, Learn Database Normalization with the help of a case study, Viewed on 11th April 2017 https://www.guru99.com/database-normalization.html Access Programmers n.d., Normalizing the Table Design, Viewed on 11th April 2017 https://www.access-programmers.com/normalizing-the-table-design.aspx