Question 1

What is the Pareto Principle? How does this principle apply to accounting database design?

Accepted Answer

The Pareto Principle is also called the 80/20 rule. When designing an accounting database, if you spend 80 percent of time and energy planning and design stages then just 20 percent of time will be spent on maintaining and updating the database. If just 20 percent of time and energy is spent on the planning and design stages, then 80 percent of time will be spent on maintaining and updating the database.

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

Which of the following statements is NOT a benefit associated with entering data once into a database?

Accepted Answer

A) Reentering the same data again and again increases the chances of entering erroneous data, such as misspellings and transpositions. 
B) It increase the opportunity to enter data incorrectly. 
C) When you need to update the customer's address, you only need to update it once. This eliminates the possibility of updating some, but not all, of the other entries. 
D) It is more efficient. You do not spend non-value-added time reentering the same information again and again. 
A) Reentering the same data again and again increases the chances of entering erroneous data, such as misspellings and transpositions. 
B) It increase the opportunity to enter data incorrectly. 
C) When you need to update the customer's address, you only need to update it once. This eliminates the possibility of updating some, but not all, of the other entries. 
D) It is more efficient. You do not spend non-value-added time reentering the same information again and again. B

Question 4

According to the Pareto Principle, if you spend 80% of the time designing a database, you will spend 20% of your time maintaining the database.

Accepted Answer

A) True 
 B)False

Question 5

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?

Accepted Answer

A) The database is working correctly. 
B) Nancy Smith's order was entered incorrectly. 
C) The same customer was entered into the database multiple times. 
D) The address information was updated for the wrong Nancy Smith. 
A) The database is working correctly. 
B) Nancy Smith's order was entered incorrectly. 
C) The same customer was entered into the database multiple times. 
D) The address information was updated for the wrong Nancy Smith.

Question 6

Dirty data occurs when errors are entered into a system.

Accepted Answer

A) True 
 B)False

Question 7

One of the disadvantages of a relational database is that we can enter data once into the database, and then reuse that data in various locations where it is needed.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

The answer of Data stored in a ________ may be...

Question 9

What does the DBMS software do?

Accepted Answer

The DBMS software does the following.
1.

Question 10

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?

Accepted Answer

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. 
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 11

You are an intern in a large company. The company would like to improve the communications between the accountants and IT. Because of your background in AIS, you are asked to train the accountants. Your assignment is to describe to your colleagues how data flows through the accounting system architecture when a new customer is entered in the accounting software.

Accepted Answer

The answer should include the following

Question 12

When using an accounting database system, such as QuickBooks, what happens when an existing customer name is entered on an onscreen invoice form?

Accepted Answer

A) The DBMS retrieves tax information and inserts it into the invoice. 
B) The DBMS retrieves address and contact information and inserts it into the invoice. 
C) The DBMS prompts you to enter the address and contact information. 
D) The DBMS retrieves inventory information and inserts it into the form. 
A) The DBMS retrieves tax information and inserts it into the invoice. 
B) The DBMS retrieves address and contact information and inserts it into the invoice. 
C) The DBMS prompts you to enter the address and contact information. 
D) The DBMS retrieves inventory information and inserts it into the form.

Question 13

You are an intern in a large company. The company would like to improve the communications between the accountants and IT. Because of your background in AIS, you are asked to train the accountants. Your assignment is to describe how data flows through the accounting system architecture when a report is run against the database. Start with requesting the report.

Accepted Answer

The answer should include the following

Question 14

Data stored in a data warehouse is used for routine business activities.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is NOT a tier in the accounting system architecture?

Accepted Answer

A) Report tier 
B) Database tier 
C) User tier 
D) Application tier 
A) Report tier 
B) Database tier 
C) User tier 
D) Application tier

Question 16

Which tier in the accounting system architecture that consists of onscreen forms?

Accepted Answer

A) User tier 
B) Application tier 
C) Database tier 
D) Accounting tier 
A) User tier 
B) Application tier 
C) Database tier 
D) Accounting tier

Question 17

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

Accepted Answer

database a

Question 18

The ________ inserts, updates, and deletes data in the database.

Accepted Answer

The answer of The ________ inserts, updates, and deletes data...

Question 19

Entering data ________ reduces the change of entering errors.

Accepted Answer

The answer of Entering data ________ reduces the change of...

Question 20

Nearly all accounting information today is stored in ________.

Accepted Answer

The answer of Nearly all accounting information today is stored...

What is the Pareto Principle? How does this principle apply to accounting database design?

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

Which of the following statements is NOT a benefit associated with entering data once into a database?

According to the Pareto Principle, if you spend 80% of the time designing a database, you will spend 20% of your time maintaining the database.

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?

Dirty data occurs when errors are entered into a system.

One of the disadvantages of a relational database is that we can enter data once into the database, and then reuse that data in various locations where it is needed.

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

What does the DBMS software do?

When using an accounting database system, such as QuickBooks, what happens when an existing customer name is entered on an onscreen invoice form?

Data stored in a data warehouse is used for routine business activities.

Which of the following is NOT a tier in the accounting system architecture?

Which tier in the accounting system architecture that consists of onscreen forms?

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

The ________ inserts, updates, and deletes data in the database.

Entering data ________ reduces the change of entering errors.

Nearly all accounting information today is stored in ________.

Accounting Systems Insights

Accounting Interface: Database Forms, Queries, and Reports

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Database Design: ERD, REA, and SQL

Filters

Exam 2: Accounting Databases

What is the Pareto Principle? How does this principle apply to accounting database design?

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

Which of the following statements is NOT a benefit associated with entering data once into a database?

According to the Pareto Principle, if you spend 80% of the time designing a database, you will spend 20% of your time maintaining the database.

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?

Dirty data occurs when errors are entered into a system.

One of the disadvantages of a relational database is that we can enter data once into the database, and then reuse that data in various locations where it is needed.

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

What does the DBMS software do?

When using an accounting database system, such as QuickBooks, what happens when an existing customer name is entered on an onscreen invoice form?

Data stored in a data warehouse is used for routine business activities.

Which of the following is NOT a tier in the accounting system architecture?

Which tier in the accounting system architecture that consists of onscreen forms?

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

The ________ inserts, updates, and deletes data in the database.

Entering data ________ reduces the change of entering errors.

Nearly all accounting information today is stored in ________.

Accounting Systems Insights

Accounting Interface: Database Forms, Queries, and Reports

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Database Design: ERD, REA, and SQL

Filters