What is the update anomaly?

The update anomaly results from data redundancy in an unnormalized table. The data attributes pertaining to particular entity (for example: Vendor Name, Address, and Tele Num) are repeated in every record in every record pertaining to the vendor. Any change in the supplier's name, address, or telephone number must then be made to each of these records. This causes an update problem that results in excessive overhead costs.