Explain the three types of anomalies associated with database tables that have not been normalized
The update anomaly is the result of data redundancy. If a data element is stored in more than one place, it must be updated in all places. If this does not happen, the data are inconsistent.
The insertion anomaly occurs when too data is stored together, such as when vendor information is only stored with specific inventory items. Until items are purchased from a given vendor, the vendor cannot be added to the database.
The deletion anomaly involves the unintentional deletion of data from a table. If a vendor supplies only one item, and the firm discontinues that item, all information on the vendor is lost when vendor information is only stored with specific inventory items.
You might also like to view...
What condition is not necessary in order to use the retail method to provide inventory results?
a. Retailer keeps a record of the total costs of products sold for the period. b. Retailer keeps a record of the total costs and retail value of goods purchased. c. Retailer keeps a record of the total costs and retail value of goods available for sale. d. Retailer keeps a record of sales for the period.
An insurance company may avoid liability if the insured concealed information on the
application to obtain insurance coverage. Indicate whether the statement is true or false