Importance of Database Normalization

Normalization is a process to eliminate the flaws of a database with bad design. A poorly designed database is inconsistent and create issues while adding, deleting or updating information.

The following makes Database Normalization a crucial step in database design process −

Resolving the database anomalies

The forms of Normalization i.e. 1NF, 2NF, 3NF, BCF, 4NF and 5NF remove all the Insert, Update and Delete anomalies.

Insertion Anomaly occurs when you try to insert data in a record that does not exist.

Deletion Anomaly is when a data is to be deleted and due to the poor deign of database, other record also deletes.

Eliminate Redundancy of Data

Storing same data item multiple times is known as Data Redundancy. A normalized table do not have the issue of redundancy of data.

Data Dependency

The data gets stored in the correct table and ensures normalization.

Isolation of Data

A good designed database states that the changes in one table or field do not affect other. This is achieved through Normalization.

Data Consistency

While updating if a record is left, it can led to inconsistent data, Normalization resolves it and ensures Data Consistency.

Ricky Barnes

Updated on 15-Jun-2020 13:37:15

• Related Questions & Answers
• Database Normalization
• Importance of Entity-Relationship diagram in database design
• Explain the concept of Normalization in DBMS?
• Difference between Normalization and Denormalization
• Matrix Multiplication and Normalization in C program
• Importance of HashSet in Java
• De-normalization and Analytic views in SAP HANA
• What is the importance of hygiene?
• Importance of function prototype in C
• Importance of StringReader class in Java?
• Importance of clone() method in Java?
• Importance of isDaemon() method in Java?
• Importance of XOR operator in Java?
• Importance of return type in Java?
• Importance of yield() method in Java?