Home » MCQs » DBMS MCQs » DBMS Decomposition Algorithms MCQs

Which of the following is TRUE about BCNF Decomposition Algorithm?

10. Which of the following is TRUE about BCNF Decomposition Algorithm?

1. To decompose a given relation R, this algorithm consists of decomposing it into several decomposers.
2. The decomposition of the relation R is performed by using dependencies that show the violation of BCNF.
3. In addition to producing decomposers for relation R in BCNF, such an algorithm also produces lossless decompositions.
4. All of the above

Answer: D) All of the above

Explanation:

In case of BCNF Decomposition Algorithm -

1. To decompose a given relation R, this algorithm consists of decomposing it into several decomposers.
2. The decomposition of the relation R is performed by using dependencies that show the violation of BCNF.
3. In addition to producing decomposers for relation R in BCNF, such an algorithm also produces lossless decompositions.