Home » MCQs » DBMS MCQs » DBMS Normalization MCQs

What is TRUE about BCNF?

20. What is TRUE about BCNF?

1. The advanced version of 3NF is BCNF.
2. BCNF is stricter than 3NF.
3. The super key is X for any functional dependency of X -> Y in the table.
4. All of the above

Answer: D) All of the above

Explanation:

In case of BCNF -

1. The advanced version of 3NF is BCNF.
2. BCNF is stricter than 3NF.
3. The super key is X for any functional dependency of X -> Y in the table.