Home > Uncategorized > What is Normalization and Denormalization in data base?

What is Normalization and Denormalization in data base?


Normalization is a database designing technique which makes sure that there will not be any redundant data.

  • It makes our data more reliable (because there will not be any repeating data. Exiting data will be referred wherever required)
  • It makes database management easy.
  • It reduces the size of database.

Following tables are the part of normalized database.

CityId CityName
1 Hyd
2 New york
3 FrankF
CustomerId CustomerName CityId
1 Microsoft 1
2 Google 1
3 MetLife 2
4 Lutha 3

Denormalization : Storing data in to the database with repeating data, we will repeat the same data wherever required. Denormalized version of above example looks like,

CustomerId CustomerName CityName
1 Microsoft Hyd
2 Google Hyd
3 MetLife New York
4 Luftha FrankF
Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: