Question: Show that the relation schemas produced by Algorithm 15.5 are in BCNF. Algorithm 15. 5. Relational Decomposition into BCNF with Nonadditive Join Property Input: A

Show that the relation schemas produced by Algorithm 15.5 are in BCNF.

Algorithm 15.5. Relational Decomposition into BCNF with Nonadditive Join Property

Input: A universal relation R and a set of functional dependencies F on the attributes of R.

1. Set D := {R} ;
2. While there is a relation schema Q in D that is not in BCNF do

{
choose a relation schema Q in D that is not in BCNF;

find a functional dependency X → Y in Q that violates BCNF;

replace Q in D by two relation schemas (Q − Y) and (X ∪ Y);

} ;

Step by Step Solution

3.42 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Answer The relation schemas produced by Algorithm 155 are in BCNF because the algorithm only ... View full answer

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 Fundamentals Of Database Systems Questions!