Question discussion

A relation R(A, B, C) has the functional dependencies AB → C and C → B. In which normal form is R?

1126Medium DSSSB TGT Computer Science 0 replies 1 views
0

A relation R(A, B, C) has the functional dependencies AB → C and C → B. In which normal form is R?

  • A1NF but not 2NF
  • B2NF but not 3NF
  • CBCNF
  • D3NF but not BCNF
Correct answer: D

Explanation

The candidate keys are AB and AC, so every attribute is prime and 3NF holds; but C → B has a determinant (C) that is not a superkey, so BCNF fails.

Discussion 0

Nobody has replied yet. Start the discussion!