Hi, Deletion Anomaly example: A situation, usually caused by redundancy in the schema, in which the deletion of one row of a table results in the deletion of an unintended information. Insetion Anomaly example: A situation, usually caused by redundancy in the schema, in which the insertion of a row in a table creates an inconsistency with other rows. Update/Modifying Anomaly example:
A situation, usually caused by redundancy in the schema, in which an update to one value affects another value. An update anomaly may be a deletion anomaly, an insertion anomaly, or a modification anomaly. riccardi.pearsoncmg.com
A situation, usually caused by redundancy in the schema, in which an update to one value affects another value. An update anomaly may be a deletion anomaly, an insertion anomaly, or a modification anomaly. riccardi.pearsoncmg.com
