What is normalization?

What is normalization?

What is normalization?

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:
what is bit
what is hibernate.archive.autodetection
Advertisements
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
What is procedure
what is hibernate.archive.autodetection
What is Hibernate
What is Hibernate
What is JDBC?
What is FBT
What is ActionServlet?
What is Trigger?
What is VLR ?
What's PHP ?
What is an interface?
What is DML?
What is Index?
What is SQLLoader?
What is a "constraint"?
what is Savepoint ?
What is this keyword?
what is collections?
what are indices?
What is Hibernate
What is Hibernate
What is Externalizable?
What is the % operator?
What is casting?
What is IOC ?
What is SQLExceptionTranslator?
What is DataAccessException?
What are Struts?
What is WAP?
What is SPOOL?
What is CRM?
What is webservices?
What is Ajax?
What is NSRangeException
What is portal
what is posting?
What is a tuple?
What is workflow
what is RUP?
What was ENIAC
What is an Iterator?
What is WSP?
What is CDPD ?
What is RMS ?

Ads