You are an accountant at a small company and you are reviewing the vendor database table. Identify the database anomalies shown and explain how they impact this database
What will be an ideal response?
Answer: This database contains the deletion anomaly, update anomaly, and the insertion anomaly.
The deletion anomaly in this database prevents the deletion of a vendor. If a vendor was deleted, the information for a purchase order would also be deleted, deleting the purchase order information which is needed for various management and financial reports.
The update anomaly in this database means if the phone number for a vendor changes, additional records would need to be updated to reflect that change.
The insertion anomaly in this database means a new vendor cannot be added to the database until the company submits a purchase order to the vendor.
You might also like to view...
Farmer Company issues $20,000,000 of 10-year, 9% bonds on March 1, 2012 at 97 plus accrued interest. The bonds are dated January 1, 2012, and pay interest on June 30 and December 31. What is the total cash received on the issue date?
a. $19,400,000 b. $20,450,000 c. $19,700,000 d. $19,100,000
On December 31, 2016, Axle Services, Inc. prepared the following accrual adjustment:
Salaries Expense 1,000 Salaries Payable 1,000 Axle uses reversing entries. Prepare the reversing entry that would be prepared on January 1, 2017. What will be an ideal response