Database Normalization

Question: Examine about the Database Normalization Answer: Reliance Diagram The reliance graph 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 Mentor (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 analysis, 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