Normal Forms

Introduction

Normalization is a process that is used for organizing the data in the database by removing data redundancy and improving data integrity. The primary goal of normalizing a given relation is to get rid of Insert, Delete, and Update abnormalities.

This multi-step process involves structuring the database's columns and tables to guarantee that the relationships between columns and tables are correctly enforced by database integrity constraints. In order to be more effective, the normalization procedure typically involves dividing huge tables into smaller ones. Edgar F. Codd established the First Normal Form in 1970, and later, other Normal Forms were defined.