Normalization

A database in the 1st normal form does not have multivalued columns like the one below.

Name | PhoneNumber

John | 122345, 456879

In a database which is already in the 1st normal form, if all columns are functional dependent on the whole key, then the database is said to be in the 2nd normal form.

In a database, if all the columns are directly dependent on the whole key then the database is said to be in the 3rd normal form.