🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.BCNF decomposition is always dependency preserving
  2. B.3NF decomposition can be lossy
  3. C.Neither can be lossless
  4. 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 →