Question: 3. For the universal relation R(a, b, c, d), consider the decomposition D consisting of Ri(a, b) and R2(b, c, d), and the set Fof

3. For the universal relation R(a, b, c, d), consider the decomposition D consisting of Ri(a, b) and R2(b, c, d), and the set Fof functional dependencies { ab.c ; b-) a,d ; c-) a,d } a. Compute the projection of F on Ri b. Compute the projection of F on R2. c. Does the decomposition D preserve the set of dependencies F? Give a detailed explanation why or why not. (That is, don't just repeat back the definition of the dependency preservation property, but rather show why the decomposition D either has or does not have this property.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
