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

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

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 Mathematics Questions!