What is Database Normalization? Types of Normalization? |
| |
|
|
|
New Coder Posts: 49 Topics: 14
|
|
|
September 11, 2008, 12:16:20 AM
|
|
What is normalization? why we need to do this. Normalization is the process of breaking your data into separate components to reduce the repetition of data. Normalization can be up to 5 level. Each level of normalization reduce the repetition of data. it can be first/Second/Third and BCNF
« Last Edit: July 15, 2011, 08:50:49 AM by Admin »
|
|
| |
|
|
|
|
Regular Coder Posts: 50 Topics: 15
|
|
|
September 15, 2008, 09:35:43 AM
|
|
Normalization can be done at five levels but you did not describe the five levels rightly.
It can 1NF
2NF
3NF
BCNF
4NF
5NF
but people generally prefer going till 3NF only..
|
|
| |
|
|
|
|
New Coder Posts: 49 Topics: 14
|
|
|
September 15, 2008, 10:10:44 PM
|
|
Yes you are true. i have also tried upto 3rd level that is BCNF. as i think it is more complicated with the next level of normalization after BCNF but why all the books mentioned 4th and 5th if nobody is using them.
|
|
| |
|
|
|
|
Regular Coder Posts: 67 Topics: 33
|
|
|
January 02, 2009, 12:36:44 AM
|
|
as said above the normalisation is of 5 forms but only 3 normal forms are used. the reason is there might not be use of the 4th and the 5th normal form as the database works well with the existing 3 normal forms. when the output is not got we then work with the advanced forms, untill they will not be used.
|
|
| |
|
|
|
Code Guru
Location: India
Gender:  Posts: 1387 Topics: 105
 
|
|
|
January 02, 2009, 04:36:52 AM
|
|
Yeah that's true, in most of the projects normalization up to 3 levels solve the data problems. It's hardly when someone need to go for the next advanced level 4 and 5 of normalization.
|
|
| |
|
|
|
|
New Poster Posts: 1 Topics: 0
|
|
|
June 10, 2010, 03:03:30 AM
|
|
thanx for sharing
Web Development Services
|
|
| |
|
|
|
|
New Poster Posts: 11 Topics: 0
|
|
|
February 04, 2011, 12:11:13 AM
|
|
In relational database design, the process of organizing data to minimize redundancy is called normalization.
|
|
| |
|
|
|
|
Skilled Coder Posts: 125 Topics: 0
|
|
|
March 06, 2011, 10:32:27 PM
|
|
Normalization is the process of arranging data to minimize redundancy.
|
|
| |
|
|
|
Skilled Coder Real name: Janne
Location: california
Gender:
Posts: 108 Topics: 1
|
|
|
April 29, 2011, 02:37:48 AM
|
|
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data and ensuring data dependencies . . . . . . . . . . . . .
|
|
| |
|
|
|
|
Skilled Coder Posts: 149 Topics: 0
|
|
|
June 07, 2011, 05:43:30 AM
|
|
In the design of a relational database management system (RDBMS), the process of organizing data to minimize redundancy is called normalization. The goal of database normalization is to decompose relations with anomalies in order to produce smaller, well-structured relations. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective 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.
|
|
| |
|
|
|
Professional Coder Real name: Odusee
Location: Australia
Gender:  Posts: 458 Topics: 47
|
|
|
June 07, 2011, 11:43:27 PM
|
I usually do my Normalization up till 3NF. Nice and informative posts 
|
|
| |
|
|
|
|
Professional Coder Gender: Posts: 242 Topics: 3
|
|
|
July 11, 2011, 06:07:09 AM
|
|
It is the process of organizing data to minimize redundancy..
|
|
| |
|
|
|
|
Regular Coder Gender:
Posts: 60 Topics: 10
|
|
|
July 15, 2011, 02:04:56 AM
|
|
Actually normalization is the process of organizing data to minimize redundancy.
Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective 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.
Basically you have to normalize your database upto 3 levels
1st normal form
2nd normal form
3rd normal form
|
|
| |
|
|
|
|
Regular Coder Posts: 93 Topics: 34
|
|
|
August 18, 2011, 11:01:01 PM
|
|
Hi,
I agree with you you give me such a nice solutions. And it is very useful.
Thanks for sharing me.
|
|
| |
