Tuesday, 21 August 2012

3rd Normal Form(3NF)

A table in 3rd normal form if
  • It is in 2NF
  • It contains no transitive dependencies
If a transitive dependency exists it is removed by placnig the appropriate attribute in a new relation along with their determinant.

No comments:

Post a Comment