Explain normalization with example (1NF, 2NF, 3NF)

Data Science, AI and ML
1

Sql, Normalization

2

Normalization is a process of organizing the data in a database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly. In other words it divides larger tables into smaller tables and links them by using a relationship.

1600×699 238 KB

1600×900 262 KB

2 Likes
3

Normalization is altering your data model to remove redundancy, ambiguity and indirection from your data. Attempts to normalize are often ways of finding bad or misleading data.

First Normal Form

• 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.

Second Normal Form

• Create separate tables for sets of values that apply to multiple records.

• Relate these tables with a foreign key.

Third Normal Form

• Eliminate fields that do not depend on the key.