Which of the following is true?
2012
Which of the following is true?
- A.
A relation in BCNF is always in 3NF
- B.
A relation in 3NF is always in BCNF
- C.
BCNF and 3NF are same
- D.
A relation in BCNF is not in 3NF
Attempted by 354 students.
Show answer & explanation
Correct answer: A
Boyce-Codd Normal Form (BCNF) is a stricter normalization form than Third Normal Form (3NF). Every relation that satisfies BCNF automatically satisfies all conditions of 3NF. However, the converse is not true; a relation can be in 3NF without being in BCNF. Thus, the statement that BCNF implies 3NF is theoretically correct.
A video solution is available for this question — log in and enroll to watch it.