Question: 3 . [ 1 2 points ] Consider a relation R = ( A , B , C , D , E , F )

3.[12 points] Consider a relation R =(A, B, C, D, E, F) and a set S ={AB C, AC B, AD E, B D, BC A, D E} of functional dependencies that hold over R. Assume that R was decomposed into R1(B, D, E, F) and R2(A, B, C) and that S1 is the set of functional dependencies that hold over R1 and S2 is the set of functional dependencies that hold over R2.
3.1.[7 points] Compute S2, the projection of S on relation R2. Show your work.
3.2.[5 points] Provide a key for R2(A, B, C) with respect to the set of functional dependencies S2 you calculated in part 3.1. Show your work.

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 Finance Questions!