Question

What does the BCNF decomposition algorithm do?

(a) States a method to decompose a relation satisfying BCNF

(b) States a method for joining two relations satisfying BCNF

(c) States a method to decompose a relational schema such that there are no multiple occurrences

(d) None of the mentioned

The question was posed to me by my college director while I was bunking the class.

My doubt is from Decomposition Algorithms topic in division Relational Database Design of RDBMS

Answer 1

Correct choice is (a) States a method to decompose a relation satisfying BCNF

For explanation I would say: If a relation is not in BCNF, it can be decomposed into simpler relations that are in BCNF. The BCNF decomposition algorithm states a method to decompose a relation satisfying BCNF.