Question discussion

R(A, B, C, D) has the dependencies AB → C, C → D and D → A. How many candidate keys does R have?

934Medium DSSSB TGT Computer Science 0 replies 1 views
0

R(A, B, C, D) has the dependencies AB → C, C → D and D → A. How many candidate keys does R have?

  • A3
  • B1
  • C2
  • D4
Correct answer: A

Explanation

B appears on no right-hand side, so it is in every key; AB, BC and BD each have closure ABCD, giving 3 candidate keys.

Discussion 0

Nobody has replied yet. Start the discussion!