← Quiz: Functional Dependencies: all 15 questions
Quiz: Functional Dependencies · Question 10 of 15
Which statement about BCNF and 3NF decomposition is true?
Which statement about BCNF and 3NF decomposition is true?
- A.BCNF decomposition is always dependency preserving
- B.3NF decomposition can be lossy
- C.Neither can be lossless
- D.3NF can always be lossless and dependency preserving; BCNF cannot always preserve dependencies
Answer & explanation
Correct answer: 3NF can always be lossless and dependency preserving; BCNF cannot always preserve dependencies
That trade-off is why some designs stop at 3NF.
Can you get the rest right without peeking?
Take the timed Quiz: Functional Dependencies quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →