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.
![919_Steps of Normalization.jpg](https://www.expertsmind.com/../CMSImages/919_Steps of Normalization.jpg)
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.