Normalization

This is the process by which the data is broken up into groups for efficient processing. This process involves assigning record numbers to key groups such as Products and Customers.

At the same time no fields would contain duplicate information, as such any required duplicate information would be placed into a table itself and assigned a record number.

The record numbers would then tie the tables together.

While the database is made more complex overall it would then be easier to maintain.

Data that is not normalized risks having inconsistencies such as a customers phone number in one record could change and not be updated within multiple records. When the data is normalized you have a unique record for that customer and thus one record to update.

Eraserve ap offers this service. See our Data Services page.