Example & Tutorial understanding programming in easy ways.

What is Anomaly problem?

Basically, Anomaly problem is occur when the relational table is not Normalized.


There are three types of anomaly problem in the table:

1. Insertion anomaly

2. deletion anomaly

3. updation anomaly


1. Insertion anomaly: In un-normalized table , when we insert some data then there may be chance that some data are repeated that means redundancy occur so this kind of problem is called as insertion anomaly


2. Deletion anomaly: When we delete some record of some column then there may be chance that some record automatically deleted so this kind of problem is called as deletion anomaly


3.Updation anomaly: When we want to change only one detail like one person detail then some time possible you have to update whole table in order to update one record then this is problem called as updation anomaly.


Normalization process solve the anomaly problem

Read More →