-- Normalization (OLTP)



    Normalization is the process of organizing the data in the database.

    

	Normalization is used to minimize the redundancy from a relation or set of relations. 

	It is also used to eliminate undesirable characteristics like Insertion, Update, and Deletion Anomalies.

    

	Normalization divides the larger table into smaller and links them using relationships.

    

	The normal form is used to reduce redundancy from the database table.





	NF1 : Each table cell should contain a single value.

	NF2 

	NF3  

	NF4

	

						  

Advantages of Normalization



    Normalization helps to minimize data redundancy.

    Greater overall database organization.

    Data consistency within the database.

    Much more flexible database design.

    Enforces the concept of relational integrity.