Database Normal Form Rules

1st Normal Form

  1. All column values are atomic.
  2. No repeating groups.

2nd Normal Form

  1. All non-key attributes are fully determined by the composite primary key.

3rd Normal Form

  1. No transitive dependencies between any attributes.

Read a full description in the MySQL article An Introduction to Database Normalization.