Database Dependency Diagram of the Provided Un-Normalised Table

Question: Discuss about the Dependency Diagram of the Provided Un-Normalised Table. Answer: Dependency Diagram The above diagram is the dependency diagram of the provided un-normalised table. The partial and transitive dependency is occurring in the fields as shown above. 3NF Relations (teach-ict.com n.d.) Relational Schema Trainer (Trainer_ID, Trainer_Name) Primary Key - Trainer_ID Room (Room_No, Room_Name, School) Primary Key - Room_No ClassSession (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) (P. Brombarg, n.d.) References teach-ict.com n.d., Third Normal Form, [Online]. Available: https://www.teach-ict.com/as_a2_ict_new/ocr/AS_G061/315_database_concepts/normalisation/miniweb/pg9.htm [Accessed: 11-April-2017] Brombarg,(n.d.) SQL SERVER Database Normalization Basics for Developers, [Online]. Available: https://www.nullskull.com/a/1629/sql-server-database-normalization-basics-for-developers.aspx. [Accessed: 11-April-2017]