What is Normalization? — Parv The IT Geek

I would simply describe this as the process of making big tables into smaller tables.

The proper definition is that database normalization is a method of reorganising data within tables to reduce the level of dependency. This helps to isolate data so that insertion, deletions and updates in a field can be made into a single table. The relationships between the tables would then propagate this throughout the database.

The goal of normalization is to reduce the amount of data within a table and also to make the data within each table make more sense.


Originally published at https://parvtheitgeek.com on January 11, 2014.

Published by Parvinder Nijjar

I blog at ParvTheITGeek.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

<span>%d</span> bloggers like this: