c) Consider the following relation R with the functional dependencies: AC—B, AD—E, AB-C, EF, BC-A, and B---D. B с E F RA

[answerhappygod]

1 (64.42 KiB) Viewed 85 times

c) Consider the following relation R with the functional dependencies: AC—B, AD—E, AB-C, EF, BC-A, and B---D. B с E F RA 1 D 3 х 2 4 9 5 10 6 у 7 8 b) c) Is {AB, BC, ABDE, EF} a lossless-join decomposition? Explain. Is the decomposition (ABC, ACDE, ADF} lossless join? Determine the projection of the set of functional dependencies of Ronto ABC, ACDE, and ADF. Is this decomposition dependency preserving? Decompose R into a set of 3NF relations, that is lossless join and dependency preserving. d)