Normal Form | Definition | Dependency Rule |
---|
1NF | A relation is in 1NF if all the attribute values are atomic and each column contains only one value per record. | All attribute values must be atomic (indivisible) and there must be no repeating groups. |
2NF | A relation is in 2NF if it is in 1NF and all non-prime attributes are dependent on the whole primary key, not just part of it. | The relation must be in 1NF and each non-key attribute must be dependent on the whole primary key. |
3NF | A relation is in 3NF if it is in 2NF and all non-key attributes are independent of each other. | For a non trivial FD, if LHS is a superkey or RHS is a prime attribute |
BCNF | A relation schema R is in Boyce-Codd Normal Form (BCNF) if and only if for every non-trivial functional dependency X → Y in R, X is a superkey of R. | For BCNF, the table should be in 3NF, and for every FD, LHS is super key. |