What is the meaning of Database normalization

Asked By mila james 30 points N/A Posted on - 03/09/2012

Hi guys, 

Can anyone please explain me what is Database normalization and why it's important.

Need answers quickly.

• Status: Open
• Question Views: 2278
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Sharath Reddy

Go To Solution

Answered By alamarie21 0 points N/A #94578

What is the meaning of Database normalization

Database normalization is the process of organizing the fields and table of a relational database to minimize redundancy and dependency. It involves dividing large tables into smaller one to avoid redundancies.

This is important in order to isolate data so that addition,deletion and modification of a field is just in a one table and then propagated to the rest database via the defined relationships.

Another take into consideration is that it is difficult to store object into a relational database that maintains the same information in several places.

The advantage of this is that data is stored in one place only so it reduced the possibility inconsistent data.

About alamarie21

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/09/2012
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #94580

What is the meaning of Database normalization

Database normalization is the manner of arranging or managing the tables and fields of a relational database to lessen dependency and redundancy. It normally requires dividing or splitting huge tables into smaller ones and then describing relationships between them.

The idea is to separate data so that modifications, deletions, and or additions made on a field can be done in only one table and then spread through the remainder of the database by means of the defined relationships.

This will surely avoid any redundancy since the process only needs to modify a single table then circulate the result to the entire database afterwards. In 1970, the idea of normalization was initiated by the inventor of the relational model, Edgar F. Codd. It is known as the First Normal Form or 1NF.

It was then followed by Second Normal Form [2NF] and Third Normal Form [3NF] in 1971. After that, in 1974, Edgar F. Codd together with Raymond F. Boyce defined the BCNF or the Boyce-Codd Normal Form.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 04/10/2013
• Question Category: MySQL Server