The process of removing anomalies from the database so that it would become consistence is called normalization process.Data normalization is the process of grouping the data elements into a set of tables representing entries, and their relationship. Here under are defined three steps, in the process of normalizing data:

First Normal Form:
It is the first step, demanding to remove any repeating groups from the relation. A relation is in the first normal form (1NF), if and only if, every attribute is single valued, for each table, i.e. each attribute in each row of the table contains only one value.

Second Normal Form:
This step is available to ensure that, if the relation has a composite key then data attribute in the relation should be functionally dependent upon the whole key and not just a part of key. A data attribute, which is functionally dependent upon just a part of composite key, should be removed to form a new relation.

Third Normal Form:
The third step is to remove any functional attributes, which are dependent upon other attributes and put them in the separate relation. When it has taken the data in third normal form, third normal form is perfectly adequate for almost any commercial DBMS.