Question: 3. Consider a relation schema R with attributes ABCDEF GH with functional dependencies S: S = (B - CD, BF - H, C - AG,

3. Consider a relation schema R with attributes ABCDEF GH with functional dependencies S: S = (B - CD, BF - H, C - AG, CEH - F, CH - B} (a) Which of these functional dependencies violate BCNF? [3 points] (b) Employ the BCNF decomposition algorithm to obtain a lossless decomposition of R into a collection of relations that are in BCNF. Make sure it is clear which relations are in the final decomposition and project the dependencies onto each relation in that final decomposition. [3 points] (c) Is your decomposition dependency-preserving? Explain your answer. [3 points]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
