Steps of Normalization

Systems analysts should be familiar with the steps in normalization, because this procedure can get better the quality of design for an application. Beginning with a data store developed for a data dictionary the analyst normalizes a data structure in three steps. Every step includes an important process to simplify the data structure.

It consists of basic three steps that are as follows:

1.First Normal form, that decomposes all data, groups into 2-D records.
2.Second Normal Form, that eliminates do not fully depend on the primary key of the record.
3.Third  Normal  Form,  that  eliminates  any  relationships  which,  hold  transitive dependencies.

The relation denoted from the data store like as Employee register will most likely be unnormalized. It will consist of replicate groups and record will not be of fixed length.