Outline of database design paradigm

First paradigm

Each row in a table must have only unique row values. Each column in a row has only unique values and is atomic.

Second paradigm

The second paradigm requires that the non-primary key column is a subset of the primary key, and the activity of the non-primary key column must be completely dependent on the entire primary key. A primary key must have a unique element. A primary key can consist of one or more columns with unique values. Once created, the primary key cannot be changed. The foreign key is associated with the primary key of a table. The relationship between the primary and Foreign keys indicates a one-to-many relationship.

Third paradigm

The third paradigm requires that non-primary key columns do not depend on each other.

Fourth paradigm

The fourth paradigm prohibits one-to-multiple relationships between primary key columns and non-primary key columns from being constrained.

Fifth paradigm

The fifth paradigm divides the table into as small blocks as possible, in order to exclude all redundancy in the table.