Question 1

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 A

Question 2

Use the database tables below to answer the following questions.  
-Which of the relationships below is a many-to-many relationship?

Accepted Answer

A) VENDORS, PURCHASE ORDERS 
B) PURCHASE ORDERS, ITEMS 
C) ITEMS, PO LINE 
D) PO LINE, VENDORS 
A) VENDORS, PURCHASE ORDERS 
B) PURCHASE ORDERS, ITEMS 
C) ITEMS, PO LINE 
D) PO LINE, VENDORS B

Question 3

What IT professionals call people or things, accounting professionals call objects.

Accepted Answer

A) True 
 B)False  False

Question 4

What is an operational database and a data warehouse? How are they different?

Accepted Answer

An operational database stores data rela

Question 5

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 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

The answer of Generally, the relationship between a table that...

Question 8

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 9

When retrieving data from a hierarchical database, which of the following is false?

Accepted Answer

A) You need to know the record address of the data. 
B) You need to understand the database structure. 
C) You need to know how the tables are related. 
D) You need to understand the parent/child record relationship. 
A) You need to know the record address of the data. 
B) You need to understand the database structure. 
C) You need to know how the tables are related. 
D) You need to understand the parent/child record relationship.

Question 10

Use the database tables below to answer the following questions.  
-Which field in the PURCHASE ORDERS table is a foreign key?

Accepted Answer

A) PO No 
B) PO Date 
C) Shipping 
D) Vendor ID 
A) PO No 
B) PO Date 
C) Shipping 
D) Vendor ID

Question 11

An intersection table's primary key is a(n)________.

Accepted Answer

The answer of An intersection table's primary key is a(n)________....

Question 12

To create a relational database based on the payroll cycle, which types of data should be recorded in the database?

Accepted Answer

A) Employee information and sales invoices 
B) Employee information and number of hours worked 
C) Number of hours worked and inventory information 
D) Number of hours worked and purchase orders 
A) Employee information and sales invoices 
B) Employee information and number of hours worked 
C) Number of hours worked and inventory information 
D) Number of hours worked and purchase orders

Question 13

What are the basic steps for creating an intersection table?

Accepted Answer

Step 1: Identify a many-to-many relation

Question 14

Use the database tables below to answer the following questions.  
-Which of the relationships below is a many-to-many relationship?

Accepted Answer

A) TimeSheets, Projects 
B) Employee, TimeSheets 
C) TimeSheets, TS Line 
D) Projects, TS Line 
A) TimeSheets, Projects 
B) Employee, TimeSheets 
C) TimeSheets, TS Line 
D) Projects, TS Line

Question 15

To answer the following questions, refer to the database below.  
-When a database has been normalized, which of the following is true?

Accepted Answer

A) The database has an increased chance of redundancies. 
B) The database has an increased chance of inconsistencies. 
C) The database requires the user to enter data twice. 
D) The database tables do not have a many-to-many relationship. 
A) The database has an increased chance of redundancies. 
B) The database has an increased chance of inconsistencies. 
C) The database requires the user to enter data twice. 
D) The database tables do not have a many-to-many relationship.

Question 16

To maintain primary key integrity, a relational database designer will not allow a primary key to have a null (empty)value.

Accepted Answer

A) True 
 B)False

Question 17

Describe the architecture of an accounting system. In which tier does each element reside?

Accepted Answer

The accounting system architecture consi

Question 18

To answer the following questions, refer to the database below.  
-When requiring a user to select from a list to enter data, such as the state in an address, the database is conforming to which database integrity rule?

Accepted Answer

A) Referential Integrity 
B) Domain Integrity 
C) Primary Key Integrity 
D) Entity Integrity 
A) Referential Integrity 
B) Domain Integrity 
C) Primary Key Integrity 
D) Entity Integrity

Question 19

To answer the following questions, refer to the database below.  
-Which database integrity rule ensures each record may be retrieved from the database using a unique identifier?

Accepted Answer

A) Domain Integrity 
B) Primary Key Integrity 
C) Entity Integrity 
D) Referential Integrity 
A) Domain Integrity 
B) Primary Key Integrity 
C) Entity Integrity 
D) Referential Integrity

Question 20

In which phase of the SDLC is DBMS software used to transform the database model into an actual database?

Accepted Answer

A) Analysis phase 
B) Design phase 
C) Build/Buy phase 
D) Install phase 
A) Analysis phase 
B) Design phase 
C) Build/Buy phase 
D) Install phase

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

Use the database tables below to answer the following questions. -Which of the relationships below is a many-to-many relationship?

What IT professionals call people or things, accounting professionals call objects.

What is an operational database and a data warehouse? 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 -Employee

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

When retrieving data from a hierarchical database, which of the following is false?

Use the database tables below to answer the following questions. -Which field in the PURCHASE ORDERS table is a foreign key?

An intersection table's primary key is a(n)________.

To create a relational database based on the payroll cycle, which types of data should be recorded in the database?

What are the basic steps for creating an intersection table?

Use the database tables below to answer the following questions. -Which of the relationships below is a many-to-many relationship?

To answer the following questions, refer to the database below. -When a database has been normalized, which of the following is true?

To maintain primary key integrity, a relational database designer will not allow a primary key to have a null (empty)value.

Describe the architecture of an accounting system. In which tier does each element reside?

To answer the following questions, refer to the database below. -When requiring a user to select from a list to enter data, such as the state in an address, the database is conforming to which database integrity rule?

To answer the following questions, refer to the database below. -Which database integrity rule ensures each record may be retrieved from the database using a unique identifier?

In which phase of the SDLC is DBMS software used to transform the database model into an actual database?

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

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

Use the database tables below to answer the following questions. -Which of the relationships below is a many-to-many relationship?

What IT professionals call people or things, accounting professionals call objects.

What is an operational database and a data warehouse? 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 -Employee

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

When retrieving data from a hierarchical database, which of the following is false?

Use the database tables below to answer the following questions. -Which field in the PURCHASE ORDERS table is a foreign key?

An intersection table's primary key is a(n)________.

To create a relational database based on the payroll cycle, which types of data should be recorded in the database?

What are the basic steps for creating an intersection table?

Use the database tables below to answer the following questions. -Which of the relationships below is a many-to-many relationship?

To answer the following questions, refer to the database below. -When a database has been normalized, which of the following is true?

To maintain primary key integrity, a relational database designer will not allow a primary key to have a null (empty)value.

Describe the architecture of an accounting system. In which tier does each element reside?

To answer the following questions, refer to the database below. -When requiring a user to select from a list to enter data, such as the state in an address, the database is conforming to which database integrity rule?

To answer the following questions, refer to the database below. -Which database integrity rule ensures each record may be retrieved from the database using a unique identifier?

In which phase of the SDLC is DBMS software used to transform the database model into an actual database?

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