--Database Design Sections-- MAIN INDEX INTRODUCTION RELATIONAL DATABASE HISTORY ...Codd's Rules ...Flat Files KEYS, Primary, Unique and Foreign ...Primary Keys NORMALISATION BASICS ...Simplified Normal Forms DATA MODEL BASICS FORMAL NORMALISATION ...First Normal Form (1NF) ...Second Normal Form (2NF) ...Third Normal Form (3NF) DATA MODELS - Orphans, 1to1 DATA MODELS - Many To Many SIMONS RULES FAQs REALCON2011 ESSEN, MAY 2011 ESSEN 2011 - Real World Example

Relational Database Design - Normalisation - 3rd Normal Form

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!