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,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!