Which of the following is true?
20082009
Which of the following is true?
- A.
A relation in 3NF is always in BCNF
- B.
A relation in BCNF is always in 3NF
- C.
BCNF and 3NF are totally different
- D.
A relation in BCNF is in 2NF but not in 3NF
Attempted by 350 students.
Show answer & explanation
Correct answer: B
In database normalization, BCNF is a stricter condition than 3NF. Every relation that satisfies BCNF automatically satisfies the requirements for 3NF, though the reverse is not always true.
A video solution is available for this question — log in and enroll to watch it.