Page 1 of 1
Based on the following functional dependencies, for the relation SCHEDULE bring it into a set of 3NF relations. Dependen
Posted: Sun May 15, 2022 1:29 pm
by answerhappygod
- Based On The Following Functional Dependencies For The Relation Schedule Bring It Into A Set Of 3nf Relations Dependen 1 (32.38 KiB) Viewed 101 times
Based on the following functional dependencies, for the relation SCHEDULE bring it into a set of 3NF relations. Dependencies: Section#, CourseID, Semester ID → RoomNo Section#, CourseID, Semester ID → Inst_ID Section#, CourseID, Semester ID → Week_day Section#, CourseID, Semester ID → Start_time Section#, CourseID, Semester ID → End_time Course_ID → Course Name RoomNo → Occupancy Instr_ID → Instr_name SCHEDULE CourseID, Section#, Semester ID, Course Name,RoomNo, Occupancy, Inst_ID, Instr_Name, Week_day, Start_time, End_time)