Show that the relation schemas produced by Algorithm 15.5 are in BCNF. Algorithm 15. 5. Relational Decomposition
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 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);
} ;
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Question Posted: