While auditing the Accounts Payable records, the auditor discovers an entry for Coffee Emporium with an address of 809 Main St., St. Louis MO and another entry for Coffee Emporium with an address of 809 Main Street, St. Louis MO. Each entry has a different vendor number. Which of the following statements is false?
A)Data was entered into the database incorrectly.
B)The onscreen form for entering vendor information correctly performed data validation.
C)The database views these as two separate accounts.
D)The data needs scrubbing.

Question

Quizplus · Accepted Answer

The fact that there are two different entries with slightly different addresses and different vendor numbers indicates that data was entered into the database incorrectly, and the data needs scrubbing. However, it is possible that the onscreen form for entering vendor information did not have data validation for the address field or that the validation was not strict enough to catch these slight differences. Therefore, statement B is false. The database would view these as two separate accounts because they have different vendor numbers.

While Auditing the Accounts Payable Records, the Auditor Discovers an Entry