🎙 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 7 of 15

R(A, B, C) is split into R1(A, B) and R2(B, C). Which FD makes the split lossless?

R(A, B, C) is split into R1(A, B) and R2(B, C). Which FD makes the split lossless?

  1. A.A → B
  2. B.B → C
  3. C.C → A
  4. D.A → C
Answer & explanation

Correct answer: B → C

The common attribute is B. If B → C, then B is a key of R2, so the join loses nothing.

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 →