← 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?
- A.A → B
- B.B → C
- C.C → A
- 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 →