Question

If a relation is in BCNF, then it is in

• A. 3 NF
• B. 4 NF
• C. 5 NF
• D. 6 NF

Hint:

N/A

Answer 1

The Correct Option is A

- BCNF (Boyce-Codd Normal Form) is a stricter version of the 3NF (Third Normal Form).
- If a relation is in BCNF, it automatically satisfies all the conditions of 3NF. This is because BCNF handles situations where a relation is in 3NF, but there are some remaining anomalies due to functional dependencies.
- However, BCNF does not necessarily imply that the relation is in 4NF, 5NF, or 6NF.
Therefore, the correct answer is 1. 3 NF.