Question discussion

A relation R(A, B, C, D) has the functional dependencies A → B, B → C and C → D. What is the highest normal form of R?

930Medium DSSSB TGT Computer Science 0 replies 1 views
0

A relation R(A, B, C, D) has the functional dependencies A → B, B → C and C → D. What is the highest normal form of R?

  • ABCNF
  • BFirst normal form
  • CThird normal form
  • DSecond normal form
Correct answer: D

Explanation

The only key is A, so there is no partial dependency (2NF holds), but the transitive dependencies B → C and C → D violate 3NF.

Discussion 0

Nobody has replied yet. Start the discussion!