FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Accounting Databases

Show Answer

Share

---

All types

Filters

Study Flashcards

Question 21

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

database a...

View Answer

Show Answer

Question 22

Essay

Review LaterAdd Note

Review Later

What does the DBMS software do?

Correct Answer

verified

The DBMS software does the following.
1....

View Answer

Show Answer

Question 23

Essay

Review LaterAdd Note

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?

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

A database table that stores data about items a business sells is used in the Sales cycle and the Purchasing cycle.

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

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

Database Management Systems does all the following except?

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

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?

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

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

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

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 -Cash Receipts

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

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

Referential integrity ensures data is consistent throughout 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 -Purchase Order

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