Database design first, second and third paradigm

The first paradigm has two tasks:

1, the elimination of duplicate data sets, the need to split the duplicate data sets into different tables;

2. Ensure that each column contains atomic data and that non-atomic columns should be split into atomic columns or split into other tables.

The second paradigm has two rules:

1, the table must conform to the first normal form condition;

2. Each column must depend on the entire key.

There are three rules of the third paradigm:

1, must conform to the second paradigm condition;

2, any column can not rely on non-key columns;

3. No derivative data is available.

This three paradigm condition requires that the data be split into smaller tables.

Database design first, second and third paradigm