Third Normal Form

Codd’s definition states that a table is in 3NF if :

  • The Table is in second normal form - duh!
  • Every non-prime attribute is non-transitively dependent (i.e. directly dependent) on every candidate key.

So that’s pretty straight-foward!

soon

Back to Top