Database normalization, or normalization, is the process of organizing the columns and tables of a relational database to reduce data redundancy and improve data integrity.
Normalization invlolves arranging attributes in relations based on dependencies between attributes,ensurring hat the dependencies are properly enforced by databaseintegrity constraints.
In other words is a technique of organizing the data in the database.
the normalization have a some rules, they divided into following normal form
1.-First Normal form
As per first normal form, no two rows of data must contain repeating group of information, the columm must have a unique value,such that multiple collumns cannot be used to fetch the same row and the must importand they have a primary key
2.-Second Normal Form
As per the second normal form there must not be any partioal dependency of any column or primary key
3.-Third Normal Form
Applies that every non-prime attribute of table must be dependent on primary key, or i can say that, there should not be the case that non-prime attribute is determined by another non-prime attribute.
