Exam 2: Accounting Databases

Data stored in a ________ may be current data, historical data, or future estimates.

What does the DBMS software do?

By using an intersection table, which field can be removed from the PURCHASE ORDERS table?

Database ________ store pieces of information about people, events, and objects.

Match the database table to the appropriate transaction cycle. A)Banking Cycle B)Payroll Cycle C)Financial Cycle D)Sales Cycle E)Purchasing Cycle -Cash Receipts

Database management system (DBMS)software transfers data from the accounting software to the database.

Use the database table below to answer the following questions. -An audit of customer records in the accounting database reveals data in the state field was entered inconsistently. Some customers' states were entered using the two letter abbreviation (MO, CA, or IA)and others were spelled out (Missouri, California, or Iowa). Which database integrity rule is not being followed? What type of controls can be implemented to prevent this in the future?

Referential integrity ensures data is consistent throughout the database.

________ provides an interface for the user to enter data in onscreen forms and view reports.

The ________ is responsible for managing the enterprise's databases.

Match the database table to the appropriate transaction cycle. A)Banking Cycle B)Payroll Cycle C)Financial Cycle D)Sales Cycle E)Purchasing Cycle -Purchase Order

Nancy Smith comes in to EspressoCoffee to provide her new address and you make the appropriate updates. When preparing a sales receipt for her a week later you notice Nancy's old address appears on receipt. What does this indicate about the database?

Match the database table to the appropriate transaction cycle. A)Banking Cycle B)Payroll Cycle C)Financial Cycle D)Sales Cycle E)Purchasing Cycle -Customer

Generally, the relationship between a table that stores customer data and table that stores sales order data is ________.

In the Database Builder Realm database programmers work with the database users to identify user requirements.

To maintain entity integrity, a relational database designer will allow multiple records to have the same primary key value.

How are hierarchical databases and network databases similar? How are they different?

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 database table that stores data about items a business sells is used in the Sales cycle and the Purchasing cycle.

Database Management Systems does all the following except?