Question: 3 . [ 1 2 points ] Consider a relation R = ( A , B , C , D , E , F )
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 RB D E F and RA B C and that S is the set of functional dependencies that hold over R and S is the set of functional dependencies that hold over R
points Compute S the projection of S on relation R Show your work.
points Provide a key for RA B C with respect to the set of functional dependencies S you calculated in part Show your work.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
