There are 3 types of Data Modification Anomalies:

Insertion Anomaly:

• When one cannot insert a tuple into a relationship due to lack of data is called as Insertion Anomaly.

Deletion Anomaly:

• When a deletion of data results in some un intended loss of important data, then it is referred to as Deletion Anomaly.

Update Anomaly:

• When an single data value requires an update for multiple rows of data to be updated, it is referred to as update Anomaly.