Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What is normalization?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
What is normalization?
1 Answer(s)      4 years and a month ago
Posted in : SQL


What is normalization?


Advertisement
View Answers

November 18, 2010 at 4:38 PM


Hi,

Normalization is basically to design a database schema such that duplicate and redundant data is avoided. If some piece of data is duplicated several places in the database, there is the risk that it is updated in one place but not the other, leading to data corruption.

purpose of the normalisation of databases is to improve the quality of data through the elimination of redundancy. The maintenance and upkeep of normalised data is a very simple process.

There is a number of normalization levels from 1. normal form through 5.normal form. Each normal form describes how to get rid of some specific problem, usually related to redundancy.

Thanks,



Related Tutorials/Questions & Answers:
Advertisements
Advertisements
 

 

 

DMCA.com