Question 1

In an REA database model,the Bill of Materials entity contains information about what?

Accepted Answer

A)  the raw materials used to make a finished product 
B)  the actual cost of the raw materials used to make a finished product 
C)  the vendor from whom the raw materials was purchased 
D)  all of the above 
A)  the raw materials used to make a finished product 
B)  the actual cost of the raw materials used to make a finished product 
C)  the vendor from whom the raw materials was purchased 
D)  all of the above A

Question 2

Which of the following diagrams represents a situation where a business that rents lawn mowers (not all of which get rented)writes separate rental agreements for each mower,so renters don't have to return all the rented items at the same time?

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D) 
  D

Question 3

Which of the following diagrams represents the cardinality pairs in a situation where a finished product requires one or more labor operations,and labor usage is recorded to specific production runs?

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D) 
  B

Question 4

The minimum cardinalities between a location,such as Warehouse,and a resource,like Inventory,will likely be 0 for all except which of the following reasons?

Accepted Answer

A)  One specific inventory item could be stored at several different warehouses. 
B)  A warehouse could be currently empty. 
C)  Not all kinds of inventory are stored at each warehouse. 
D)  Inventory could include products not yet available for sale. 
A)  One specific inventory item could be stored at several different warehouses. 
B)  A warehouse could be currently empty. 
C)  Not all kinds of inventory are stored at each warehouse. 
D)  Inventory could include products not yet available for sale.

Question 5

The temporal difference between Request Inventory and Order Inventory is reflected by the

Accepted Answer

A)  Request Inventory minimum cardinality of 1. 
B)  Request Inventory maximum of N. 
C)  Order Inventory maximum of N. 
D)  Order Inventory minimum of 0. 
A)  Request Inventory minimum cardinality of 1. 
B)  Request Inventory maximum of N. 
C)  Order Inventory maximum of N. 
D)  Order Inventory minimum of 0.

Question 6

The ________ entity is used to collect and summarize data about the raw materials,labor,and machine operations used during production of inventory.

Accepted Answer

A)  Finished Goods Inventory 
B)  Raw Materials 
C)  Issue Raw Materials 
D)  Work-in-Process 
A)  Finished Goods Inventory 
B)  Raw Materials 
C)  Issue Raw Materials 
D)  Work-in-Process

Question 7

When modeling the issuance of debt,the maximum cardinality from Disburse Cash to Issue Debt is 1 because

Accepted Answer

A)  interest is usually only paid at the maturity date. 
B)  one check is written for the total interest due. 
C)  The Issue Debt event is not related to Disburse Cash event; cash is received, not given. 
D)  The minimum cardinality would be 1, but the maximum cardinality should be N. 
A)  interest is usually only paid at the maturity date. 
B)  one check is written for the total interest due. 
C)  The Issue Debt event is not related to Disburse Cash event; cash is received, not given. 
D)  The minimum cardinality would be 1, but the maximum cardinality should be N.

Question 8

Identify the entity that stores most of the data typically found in the employee master file.

Accepted Answer

A)  Time Worked 
B)  Employee 
C)  HR 
D)  Payroll 
A)  Time Worked 
B)  Employee 
C)  HR 
D)  Payroll

Question 9

Since the same inventory items may be stored in several different warehouses,the maximum cardinality from Inventory to Warehouse is most likely

Accepted Answer

A)  0. 
B)  N. 
C)  1. 
D)  determined by the number of warehouses compared to the number of inventory items. 
A)  0. 
B)  N. 
C)  1. 
D)  determined by the number of warehouses compared to the number of inventory items.

Question 10

Where are depreciation expenses recorded in a database created using an REA modeling approach?

Accepted Answer

A)  as a resource 
B)  as an event 
C)  as an agent 
D)  Depreciation expenses would not be modeled. 
A)  as a resource 
B)  as an event 
C)  as an agent 
D)  Depreciation expenses would not be modeled.

Question 11

Relationships between resources and agents,such as Inventory and Supplier,reflect the best practice of identifying preferred and alternative suppliers for specific inventory items.Similar relationships between resources and employees can be used to model ________ and ________.

Accepted Answer

A)  cost; revenue 
B)  performance; behavior 
C)  responsibility; accountability 
D)  segregation of duties; internal control 
A)  cost; revenue 
B)  performance; behavior 
C)  responsibility; accountability 
D)  segregation of duties; internal control

Question 12

Which of the following diagrams represents the cardinality pairs for a typical,hierarchical organization?

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D)

Question 13

A dental office would likely model the relationships between the Sales event and both the Services and Supplies Resource entities as

Accepted Answer

A)  M:N. 
B)  1:1. 
C)  1:N. 
D)  0:1. 
A)  M:N. 
B)  1:1. 
C)  1:N. 
D)  0:1.

Question 14

Why is the event Issue Debt often modeled as a separate event entity?

Accepted Answer

The event Issue Debt is a special kind o

Question 15

In an REA model,rental transactions differ from sales transactions in that

Accepted Answer

A)  each rental has a part number. 
B)  each rental has a unique serial number. 
C)  rental transactions require completely different REA models than sales transactions. 
D)  All of the above are ways in which rental transactions differ from sales transactions. 
A)  each rental has a part number. 
B)  each rental has a unique serial number. 
C)  rental transactions require completely different REA models than sales transactions. 
D)  All of the above are ways in which rental transactions differ from sales transactions.

Question 16

In an REA diagram for the HR/Payroll cycle,the ________ relationship between Skills and Recruiting reflects the fact that one specific advertisement may list several specific skills and,over time,there may be several advertisements for one specific skill.

Accepted Answer

A)  1:1 
B)  1:N 
C)  M:N 
D)  0:N 
A)  1:1 
B)  1:N 
C)  M:N 
D)  0:N

Question 17

M:N agent-event relationships occur whenever an activity is performed by ________ employee and management wants to retain the ability to monitor ________ performance.

Accepted Answer

A)  more than one; group 
B)  more than one; individual 
C)  one; group 
D)  one; individual 
A)  more than one; group 
B)  more than one; individual 
C)  one; group 
D)  one; individual

Question 18

Why is cost information stored in several relational tables?

Accepted Answer

Cost information is stored in several ta

Question 19

If the actual cost of an inventory item is maintained as an attribute in the Inventory table,which inventory valuation method would an organization have to use?

Accepted Answer

A)  LIFO 
B)  FIFO 
C)  Weighted Average 
D)  Specific Identification 
A)  LIFO 
B)  FIFO 
C)  Weighted Average 
D)  Specific Identification

Question 20

In which entity would an item's standard cost information most likely be maintained?

Accepted Answer

A)  Inventory entity 
B)  Order_Inventory entity 
C)  Inventory-Order_Inventory entity 
D)  none of the above 
A)  Inventory entity 
B)  Order_Inventory entity 
C)  Inventory-Order_Inventory entity 
D)  none of the above

Exam 19: Special Topics in Rea Modeling

In an REA database model,the Bill of Materials entity contains information about what?

Which of the following diagrams represents a situation where a business that rents lawn mowers (not all of which get rented)writes separate rental agreements for each mower,so renters don't have to return all the rented items at the same time?

Which of the following diagrams represents the cardinality pairs in a situation where a finished product requires one or more labor operations,and labor usage is recorded to specific production runs?

The minimum cardinalities between a location,such as Warehouse,and a resource,like Inventory,will likely be 0 for all except which of the following reasons?

The temporal difference between Request Inventory and Order Inventory is reflected by the

The ________ entity is used to collect and summarize data about the raw materials,labor,and machine operations used during production of inventory.

When modeling the issuance of debt,the maximum cardinality from Disburse Cash to Issue Debt is 1 because

Identify the entity that stores most of the data typically found in the employee master file.

Since the same inventory items may be stored in several different warehouses,the maximum cardinality from Inventory to Warehouse is most likely

Where are depreciation expenses recorded in a database created using an REA modeling approach?

Relationships between resources and agents,such as Inventory and Supplier,reflect the best practice of identifying preferred and alternative suppliers for specific inventory items.Similar relationships between resources and employees can be used to model ________ and ________.

Which of the following diagrams represents the cardinality pairs for a typical,hierarchical organization?

A dental office would likely model the relationships between the Sales event and both the Services and Supplies Resource entities as

Why is the event Issue Debt often modeled as a separate event entity?

In an REA model,rental transactions differ from sales transactions in that

In an REA diagram for the HR/Payroll cycle,the ________ relationship between Skills and Recruiting reflects the fact that one specific advertisement may list several specific skills and,over time,there may be several advertisements for one specific skill.

M:N agent-event relationships occur whenever an activity is performed by ________ employee and management wants to retain the ability to monitor ________ performance.

Why is cost information stored in several relational tables?

If the actual cost of an inventory item is maintained as an attribute in the Inventory table,which inventory valuation method would an organization have to use?

In which entity would an item's standard cost information most likely be maintained?

Accounting Information Systems: an Overview

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Relational Databases

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Implementing an Rea Model in a Relational Database

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters

Relationships between resources and agents,such as Inventory and Supplier,reflect the best practice of identifying preferred and alternative suppliers for specific inventory items.Similar relationships between resources and employees can be used to model and .

M:N agent-event relationships occur whenever an activity is performed by employee and management wants to retain the ability to monitor performance.