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.
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.
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.
