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

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

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!