What is normalization?

 Posted by Karthikanbarasan on 1/28/2011 | Category: Sql Server Interview questions | Views: 4873 | Points: 40

Normalization is a process in RDBMS to minimize the redundancy of organising the data. It normally used to divide the tables in to one or two based on the relation between the data and organize to maintain the simplicity.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Sachinbbau on: 1/31/2011 | Points: 10
Normalization is a method of break down complex table’s structure into simple table structure by using certain rules. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective of Normalization is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships. With the help of this method we can reduce redundancy in a table and remove the problems of inconsistency and reduce the amount of space.

check more info on this link
http://www.mindstick.com/Articles/88d5a271-b369-4c0a-ae80-01e66df98b6a/?What is Normalization?

Login to post response