Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. For the universal relation R (a, b, c, d), consider the decomposition D consisting of R 1 (a, b) and R 2 (b, c,
3. For the universal relation R(a, b, c, d), consider the decomposition D consisting of R1(a, b) and R2(b, c, d), and the set F of functional dependencies { a --> b,c ; b --> a,d ; c --> a,d }.
A. Compute the projection of F on R1.
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, dont 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started