- • 1NF: A relation is in first normal form if the domain of each
attribute contains only atomic values, and the value of each attribute contains only a single value from that domain.
- • 2NF: No non-prime attribute in the table is functionally dependent
on a proper subset of any candidate key
- • 3NF: Every non-prime attribute is non-transitively dependent on every candidate key in the table. The attributes that do not contribute to the description of the primary key are removed from the table. In other words, no transitive dependency is allowed.
