3. Suppose that the relation R(a, c, d, e) has the set of functional dependencies F= { ac,d ; c+d; de,a }. Consider the

[answerhappygod]

3 Suppose That The Relation R A C D E Has The Set Of Functional Dependencies F Ac D C D De A Consider The 1 (58.7 KiB) Viewed 17 times

3. Suppose that the relation R(a, c, d, e) has the set of functional dependencies F= { ac,d ; c+d; de,a }. Consider the following decomposition of R: R(a, c) R2(c,d) R3(d, e) a. Give the projections of F on R1, R2, and R3. b. Does the decomposition have the dependency preservation property? Give a detailed explanation why or why not. (Don't just state the definition of the dependency preservation property, but rather show why the decomposition either has or does not have this property by showing whether or not each functional dependency in F can be derived from the union of the three projections.) c. Does the decomposition have the lossless join property? Give a detailed explanation why or why not. (Use the matrix test, and show each step of your work. That is, each time you change the matrix, state which functional dependency you are applying, and show the change to the state of the matrix. Answers that show only the final matrix without showing the steps taken to obtain it will receive little or no credit.)