3NF Third Normal Form in RDBMS

3NF Third Normal Form in RDBMS

3NF Third Normal Form
A relation R is in 3NF if it is in 2NF and has no transitive dependency.Here all the non-key attributes are depend on the key alone.There should not be any dependency among the non-key attributes.

 

Transitive Dependency

 Given a relation R(A,B,C,D,E)  then dependency like A-->B, B-->C   is a transitive dependency, since   A-->C is implied .