The terms “Update Anomalies” are called the problems which are the results from the un-normalized database in the Relational Database Management System (RDBMS). This is the common name given to anomalies. But if we are talking about the Update Anomalies it means we are talking about the Insertion Anomalies, Deletion Anomalies and Modification Anomalies. If these three anomalies are it means there is some inconsistency in our database. This will definitely create the problems while inserting, deleting and modifying the records in the data base entities called “tables”
These three Update Anomalies are having different impact on our database. These are classified as mentioned below:-
1) Insertion Anomalies create the problems when we are creating the inconsistency in the RDBMS database while inserting the records into the columns of the given table.
2) Deletion Anomalies create the problems when we are deleting the records without taking care of the other portion of the database. It will create the confusion due to inconsistency in the database.
3) Modification Anomalies are occurs when we are not able to modifying the records in the data base without taking care of the other facts.
To solve these kinds of problems we have to go for the term called “Normalization”. Normalization is the process of the converting the large table information into the small tables for the sake of the better way to insert, update and delete the records from the tables. Normalization is the process to reduce or duplicity and to store the similar data or records in the same table to have the snowflake schema rather than the star schema, which is suitable for the reading the data easily.
The different form of normalization like 1st normalization form (1NF) 2nd normalization form (2NF) and 3rd normalization form (3NF) are the base and foundation for designing the database for a big company and organization. If we are want to reduce the duplicate records in the database and dependencies as well not to create the confusion about the inserting, updating and deleting the records. If you are working on the project as an architect them you should know the principle of the normalization and de-normalization, which is opposite to the normalization.
I will be keep trying to get more information to explain more about this normalization and de-normalization. You can also share some knowledge on this topic.
Leave a Reply