Explain update anomalies and provide examples
What will be an ideal response?
Update anomalies occur when you have to update the same data in several different spots. If a customer, for instance, has several different kinds of accounts, and their contact information is stored in separate tables for each of those accounts, then any change in their contact information would have to be updated in each of those accounts. This greatly increases the chance of mistakes in entry and inconsistent information.
You might also like to view...
When it is a means of paying for goods and services and discharging debts, money is referred to as a:
a. store of purchasing power b. medium of exchange c. standard of value d. liquid asset
A buyer wants to use a residential property for a small business. Before closing, the buyer should
A) apply for a special use permit. B) check the zoning to determine if they use is allowed. C) call an attorney to request a variance. D) apply for a sales tax license.