Question: Question 3 2 Marks Consider the relation schema TEACH-Course, Professor. Time, Room. Student. Grade) with the following set of Functional Dependencies (FDs): CourseProfessor Time, RoomCourse

Question 3 2 Marks Consider the relation schema TEACH-Course, Professor. Time, Room. Student. Grade) with the following set of Functional Dependencies (FDs): CourseProfessor Time, RoomCourse Time, ProfessorRoom Time, Student)Room . Student, Course) Grade 3.1 What are the prime attributes of TEACH? Justify your answer (i.e., show the main steps and your working (0.5 Mark) 3.2 Justify whether TEACH Is in BCNF with respect to . If TEACH Is not in BCNF with respect to , used for computing the prime attributes). identify a BCNF decomposition for TEACH (you need to show the main steps used for identifying this BCNF decomposition) and justify whether this BCNF decomposition is dependency preserving. 1.5 Mark)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
