Normal Forms
Third Normal Form (3NF)
A relation is in 3NF if:
- It is 2NF, and
- Every non-prime column is non-transitively dependent on every
candidate key.
Non-transitive dependence
- A → B
- B → C
- Implies: A → C
- C is transitively dependent on A
- B is non-transitively dependent on A
|