Home » MCQs » DBMS MCQs » DBMS Decomposition Algorithms MCQs

A BCNF decomposition algorithm is used when a given relationship R is split into a series of relatedness relations R1, R2, ... , Rn due to its absence from the ___

7. A BCNF decomposition algorithm is used when a given relationship R is split into a series of relatedness relations R1, R2, ... , Rn due to its absence from the ___.

1. 2NF
2. 3NF
3. 4NF
4. BCNF

Answer: D) BCNF

Explanation:

A BCNF decomposition algorithm is used when a given relationship R is split into a series of relatedness relations R1, R2,..., Rn due to its absence from the BCNF.