Can Show Me The Example Of Insertion Anomaly, Deleting And Modifying Data?

1 Answers

Anonymous Profile
Anonymous answered
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

Answer Question

Anonymous