Categories
Data Base

What is Database Normalization?

Normalization is the process in which a database is designed in a way that removes redundancies, and increases the clarity in organizing data in a database.
Normalization of a database helps in modifying the design at later times and helps in being prepared if a change is required in the database design. Normalization raises the efficiency of the data base in terms of management , data storage and scalability.
Now Normalization of a database is achieved by following a set of rules called ‘forms’in creating the database.
These rules are 5 in number (with one extra one stuck in-between 3&4) and they are `1ST Normal Form or 1NF: