🌱 Description of the database normalization basics

Source

Normalization is the process of organizing data in a database

1.

Eliminate repeating groups in individual tables.
Create a separate table for each set of related data.
Identify each set of related data with a primary key.

2.

Create separate tables for sets of values that apply to multiple records.
Relate these tables with a foreign key.

3.

Eliminate fields that do not depend on the key.