What is the meaning of Database normalization

Asked By 30 points N/A Posted on -
qa-featured

Hi guys, 

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

Need answers quickly.

SHARE
Best Answer by Sharath Reddy
Answered By 0 points N/A #94578

What is the meaning of Database normalization

qa-featured

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.

Database normalization is the process of organizing the fields and table of a relational database to minimize redundancy and dependency
Best Answer
Best Answer
Answered By 590495 points N/A #94580

What is the meaning of Database normalization

qa-featured

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.

Related Questions