Question discussion

Which normal form is designed to eliminate transitive dependencies of non-prime attributes on the primary key?

2148Medium DSSSB TGT Computer Science 0 replies 1 views
0

Which normal form is designed to eliminate transitive dependencies of non-prime attributes on the primary key?

  • AFirst normal form
  • BSecond normal form
  • CFourth normal form
  • DThird normal form
Correct answer: D

Explanation

2NF removes partial dependencies, while 3NF removes the transitive dependencies of non-key attributes.

Discussion 0

Nobody has replied yet. Start the discussion!