Normalization and the importance of normalization

Paper Rating: Word Count: 729 Approx Pages: 3

Normalization is the process of successively reducing a given collection of relations to some more desirable form. The normalization process is reversible (a process of no-loss decomposition). More simply, normalization is the process of re-arrange data relationships so that it will be easy to store and retrieve data efficiently.

Normalization is specifically a pure relational theory technique. Its purpose is to examine individual items of data and place them in data groups. Each group must have a primary identifier and set of dependent attribute values. Normalization gives through understanding of the information in the system being analyzed. It also helps to identify the best data group in which to place the data. Redundant or duplicated data can also be removed through normalization.

Normalization is generally a self-auditing technique this implies that if a rule has been incorrectly or incompletely applied, a later rule will help to identify the error.

A normal form is a stage through which data passes towards the... Continue Reading