Question 1

To answer the following questions, refer to the database below.  
-The Vendor Orders table contains the following database anomalies except

Accepted Answer

A) Deletion problem 
B) Insertion problem 
C) Normalization problem 
D) Update problem 
A) Deletion problem 
B) Insertion problem 
C) Normalization problem 
D) Update problem

Question 2

To answer the following questions, refer to the database below.  
-Normalization is an optimization process that minimizes which of the following?

Accepted Answer

A) Database access 
B) Redundancy 
C) Unauthorized access 
D) Database integrity 
A) Database access 
B) Redundancy 
C) Unauthorized access 
D) Database integrity

Question 3

To retrieve data from a network database you need to know the ________ of the data.

Accepted Answer

The answer of To retrieve data from a network database...

Question 4

A database engine is another name for a database program.

Accepted Answer

A) True 
 B)False

Question 5

What are the basic steps for creating an accounting database?

Accepted Answer

Step 1: Identify and build dat

Question 6

What are the structures of a relational database, hierarchical database, and a network database? How is data retrieved from each of these types of databases?

Accepted Answer

A relational database is structured as t

Question 7

Use the database tables below to answer the following questions.  
-Which table's primary key has a composite primary key?

Accepted Answer

A) Employees 
B) TimeSheet 
C) Projects 
D) TS Line 
A) Employees 
B) TimeSheet 
C) Projects 
D) TS Line

Question 8

An intersection table transforms a many-to-many relationship to two one-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

The answer of Match the database table to the appropriate...

Question 10

The intersection table's primary key is a composite primary key.

Accepted Answer

A) True 
 B)False

Question 11

Describe the types of relationships possible between tables in a relational database. Indicate whether each relationship is desirable in a relational database.

Accepted Answer

One-to-one: In this relationship, for ea

Question 12

Acme Shoes rushed development of their new accounting system. They spent 20% of the time in the design phase. How much time will Acme spend maintaining the new accounting system?

Accepted Answer

A) 40% 
B) 75% 
C) 80% 
D) 90% 
A) 40% 
B) 75% 
C) 80% 
D) 90%

Question 13

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 14

Use the database table below to answer the following questions.  
-What suggestions would you give the database designer? How should the database be created to eliminate the database anomalies? (Be specific.)

Accepted Answer

The single table should be divided into

Question 15

The bookkeeper at the retail store Cycle Bikes enters adjusting entries using an onscreen journal. This indicates that Cycle Bikes has a manual accounting system.

Accepted Answer

A) True 
 B)False

Question 16

Describe the possible types of database issues or anomalies.

Accepted Answer

Deletion problem: This occurs when delet

Question 17

In a hierarchical database, data is retrieved using record addresses.

Accepted Answer

A) True 
 B)False

Question 18

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 prompts you to enter the address and contact information. 
B) The DBMS retrieves inventory information and inserts it into the invoice. 
C) The DBMS retrieves address and contact information and inserts it into the invoice. 
D) The DBMS retrieves tax information and inserts it into the invoice. 
A) The DBMS prompts you to enter the address and contact information. 
B) The DBMS retrieves inventory information and inserts it into the invoice. 
C) The DBMS retrieves address and contact information and inserts it into the invoice. 
D) The DBMS retrieves tax information and inserts it into the invoice.

Question 19

What is the purpose of a foreign key? Provide an example.

Accepted Answer

A foreign key is a primary key in one ta

Question 20

To answer the following questions, refer to the database below.  
-The following statements regarding the Vendor Orders table above are true except

Accepted Answer

A) The database does not break the referential integrity rule. 
B) The database requires a PO number and an item number to add a vendor record. 
C) Deleting a vendor will also delete inventory information. 
D) The database requires entering the same vendor contact information multiple times. 
A) The database does not break the referential integrity rule. 
B) The database requires a PO number and an item number to add a vendor record. 
C) Deleting a vendor will also delete inventory information. 
D) The database requires entering the same vendor contact information multiple times.

To answer the following questions, refer to the database below. -The Vendor Orders table contains the following database anomalies except

To answer the following questions, refer to the database below. -Normalization is an optimization process that minimizes which of the following?

To retrieve data from a network database you need to know the ________ of the data.

A database engine is another name for a database program.

What are the basic steps for creating an accounting database?

What are the structures of a relational database, hierarchical database, and a network database? How is data retrieved from each of these types of databases?

Use the database tables below to answer the following questions. -Which table's primary key has a composite primary key?

An intersection table transforms a many-to-many relationship to two one-to-many relationships.

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

The intersection table's primary key is a composite primary key.

Describe the types of relationships possible between tables in a relational database. Indicate whether each relationship is desirable in a relational database.

Acme Shoes rushed development of their new accounting system. They spent 20% of the time in the design phase. How much time will Acme spend maintaining the new accounting system?

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.

Use the database table below to answer the following questions. -What suggestions would you give the database designer? How should the database be created to eliminate the database anomalies? (Be specific.)

The bookkeeper at the retail store Cycle Bikes enters adjusting entries using an onscreen journal. This indicates that Cycle Bikes has a manual accounting system.

Describe the possible types of database issues or anomalies.

In a hierarchical database, data is retrieved using record addresses.

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

What is the purpose of a foreign key? Provide an example.

To answer the following questions, refer to the database below. -The following statements regarding the Vendor Orders table above are true except

Accounting Systems Insights

XBRL: Intelligent Business Reporting

Accounting and Sustainability Intelligence

Accounting and Business Intelligence

Integrated Enterprise Systems

Business Processes: Purchasing, Sales, and Payroll Cycles

Accounting Systems and Business Processes

Accounting Interface: Database Forms, Queries, and Reports

Database Design: ERD, REA, and SQL

Accounting System Development

The Risk Intelligent Enterprise: Enterprise Risk Management

Cybersecurity

Fraud and Internal Control

Filters

Exam 2: Accounting Databases

To answer the following questions, refer to the database below. -The Vendor Orders table contains the following database anomalies except

To answer the following questions, refer to the database below. -Normalization is an optimization process that minimizes which of the following?

To retrieve data from a network database you need to know the ________ of the data.

A database engine is another name for a database program.

What are the basic steps for creating an accounting database?

What are the structures of a relational database, hierarchical database, and a network database? How is data retrieved from each of these types of databases?

Use the database tables below to answer the following questions. -Which table's primary key has a composite primary key?

An intersection table transforms a many-to-many relationship to two one-to-many relationships.

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

The intersection table's primary key is a composite primary key.

Describe the types of relationships possible between tables in a relational database. Indicate whether each relationship is desirable in a relational database.

Acme Shoes rushed development of their new accounting system. They spent 20% of the time in the design phase. How much time will Acme spend maintaining the new accounting system?

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.

Use the database table below to answer the following questions. -What suggestions would you give the database designer? How should the database be created to eliminate the database anomalies? (Be specific.)

The bookkeeper at the retail store Cycle Bikes enters adjusting entries using an onscreen journal. This indicates that Cycle Bikes has a manual accounting system.

Describe the possible types of database issues or anomalies.

In a hierarchical database, data is retrieved using record addresses.

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

What is the purpose of a foreign key? Provide an example.

To answer the following questions, refer to the database below. -The following statements regarding the Vendor Orders table above are true except

Accounting Systems Insights

XBRL: Intelligent Business Reporting

Accounting and Sustainability Intelligence

Accounting and Business Intelligence

Integrated Enterprise Systems

Business Processes: Purchasing, Sales, and Payroll Cycles

Accounting Systems and Business Processes

Accounting Interface: Database Forms, Queries, and Reports

Database Design: ERD, REA, and SQL

Accounting System Development

The Risk Intelligent Enterprise: Enterprise Risk Management

Cybersecurity

Fraud and Internal Control

Filters