Database Normalization

Question: Talk about the Database Normalization Answer: Reliance Diagram The reliance chart is clarifying the reliance in the above table. The fields are reliant on one another in Trainer, Room and Class Session table. There is halfway and transitive reliance in the middle of the fields. 3NF Relations (Access Programmers n.d.) Social Schema Coach (Trainer_ID, Trainer_Name) Essential Key - Trainer_ID Room (Room_No, Room_Name, School) Essential Key - Room_No Class_Session (Trainer_ID , Room_No, Class_Session, Trainer_Name , Room_Name, Class_Name, Class_Day, School) Essential 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 assistance of a contextual investigation, Viewed on eleventh April 2017 https://www.guru99.com/database-normalization.html Access Programmers n.d., Normalizing the Table Design, Viewed on eleventh April 2017 https://www.access-programmers.com/normalizing-the-table-design.aspx