There are three types of anomalies in databases:
Update Anomaly: There might be the same information on multiple records. So if you change the information related to the entity on one record, you would have to do so for all the records otherwise inconsistencies would occur. It is also called modification anomaly.
Insertion Anomaly: This phenomenon occurs when there is information about the entity that cannot be put in any of the records because it doesn’t fulfill the basic criteria.
Deletion Anomaly:This happens when there are some facts related to the entity that you want to delete but you cannot do so as it would result in the deletion of a whole record.
You can find the examples of each of these anomalies here:
Anomalies
Update Anomaly: There might be the same information on multiple records. So if you change the information related to the entity on one record, you would have to do so for all the records otherwise inconsistencies would occur. It is also called modification anomaly.
Insertion Anomaly: This phenomenon occurs when there is information about the entity that cannot be put in any of the records because it doesn’t fulfill the basic criteria.
Deletion Anomaly:This happens when there are some facts related to the entity that you want to delete but you cannot do so as it would result in the deletion of a whole record.
You can find the examples of each of these anomalies here:
Anomalies
