Question 1

What is the minimum number of external agents that must participate in each REA event?

Accepted Answer

A)  0 
B)  2 
C)  1 
D)  3 
A)  0 
B)  2 
C)  1 
D)  3 A

Question 2

Identify the notation below that is not used to represent cardinality information.

Accepted Answer

A)  UML 
B)  (Min, Max) 
C)  DFD 
D)  Maximums only 
A)  UML 
B)  (Min, Max) 
C)  DFD 
D)  Maximums only C

Question 3

In which stage(s)of the database design process is the completed data model used?

Accepted Answer

A)  only in the systems analysis stage 
B)  only in the conceptual design stage 
C)  in both the systems analysis and design stages 
D)  neither the systems analysis nor the design stages 
A)  only in the systems analysis stage 
B)  only in the conceptual design stage 
C)  in both the systems analysis and design stages 
D)  neither the systems analysis nor the design stages D

Question 4

Which is a true statement about the REA data model?

Accepted Answer

A)  The REA data model classifies entities into three distinct categories. 
B)  The term REA is an acronym that stands for resources, entities, and agents. 
C)  Using an REA data model is not helpful when creating an R-E diagram. 
D)  The "E" in the REA data model stands for things that have an economic value to the organization. 
A)  The REA data model classifies entities into three distinct categories. 
B)  The term REA is an acronym that stands for resources, entities, and agents. 
C)  Using an REA data model is not helpful when creating an R-E diagram. 
D)  The "E" in the REA data model stands for things that have an economic value to the organization.

Question 5

Which of the following statements is true about the development of an REA model?

Accepted Answer

A)  Events that pertain to the entry of data are included in the REA model. 
B)  The objective is to model basic value-chain activities. 
C)  REA diagrams model individual transactions and data collections. 
D)  Information retrieval events are modeled as events in the REA model. 
A)  Events that pertain to the entry of data are included in the REA model. 
B)  The objective is to model basic value-chain activities. 
C)  REA diagrams model individual transactions and data collections. 
D)  Information retrieval events are modeled as events in the REA model.

Question 6

Which of the following transactions is represented by the diagram below?

Accepted Answer

A)  a lumber yard where customers may pay with cash for all purchases 
B)  a buy-here-pay-here auto dealer where a car buyer sends monthly cash payments to the dealer 
C)  a consulting firm that offers a variety of consulting services to other businesses 
D)  a department store that allows customers to carry a balance and to make installment payments, if they choose 
A)  a lumber yard where customers may pay with cash for all purchases 
B)  a buy-here-pay-here auto dealer where a car buyer sends monthly cash payments to the dealer 
C)  a consulting firm that offers a variety of consulting services to other businesses 
D)  a department store that allows customers to carry a balance and to make installment payments, if they choose

Question 7

What is the standard cardinality pattern for a relationship between an event and an agent?

Accepted Answer

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

Question 8

What is the minimum number of agents that must participate in each REA event?

Accepted Answer

A)  0 
B)  2 
C)  1 
D)  3 
A)  0 
B)  2 
C)  1 
D)  3

Question 9

Which of the following transactions is represented by the diagram below?

Accepted Answer

A)  Vendors send a bill for each inventory item purchased which is payable on receipt. 
B)  A single purchase of inventory is paid for with multiple payments. 
C)  Inventory vendors send a monthly bill for merchandise delivered. The seller does not accept or allow installment payments. 
D)  Some inventory purchases are paid for with multiple payments and some payments may apply to multiple purchases. 
A)  Vendors send a bill for each inventory item purchased which is payable on receipt. 
B)  A single purchase of inventory is paid for with multiple payments. 
C)  Inventory vendors send a monthly bill for merchandise delivered. The seller does not accept or allow installment payments. 
D)  Some inventory purchases are paid for with multiple payments and some payments may apply to multiple purchases.

Question 10

Every person in the world has a birthdate,but no person has more than one birthdate.Thus,the cardinality that exists between birthdate and people is

Accepted Answer

A)  one-to-one. 
B)  one-to-many. 
C)  many-to-many. 
D)  none of the above 
A)  one-to-one. 
B)  one-to-many. 
C)  many-to-many. 
D)  none of the above

Question 11

The REA data model

Accepted Answer

A)  is used in many areas of business and science. 
B)  was developed specifically for use in designing accounting information systems. 
C)  classifies data into relationships, entities and accounts. 
D)  all of the above 
A)  is used in many areas of business and science. 
B)  was developed specifically for use in designing accounting information systems. 
C)  classifies data into relationships, entities and accounts. 
D)  all of the above

Question 12

Relationships that affect the quantity of a resource are sometimes referred to as ________ relationships.

Accepted Answer

A)  commitment 
B)  exchange 
C)  stockflow 
D)  duality 
A)  commitment 
B)  exchange 
C)  stockflow 
D)  duality

Question 13

Helge Autoparts sells new and refurbished auto parts exclusively to auto dealers.Helge purchases inventory from distributors at trade conventions.Each time Helge makes a purchase,the company records the suppliers name,address,date,specific items purchased,price paid for each,and the total amount spent.Helge later researches the inventory items to set the customer price.The company assigns an inventory number to each item purchased and records the customer price for each item.Helge buys price tags and display supplies from Alwin Incorporated,a company that sells them at all trade conventions.All inventory and supplies purchases are immediately paid for with cash or with checks from a bank account in Helge's name.All cash received from sales are also deposited to the same bank account.Several times a year Helge rents display space at dealer conventions.A deposit is always required,and the entire fee is due the day the convention starts.Helge records the deposit and final payment,along with the convention's name and address,in the same worksheet on which purchases of inventory and supplies are recorded. Consider Helge's processes regarding the purchasing inventory and supplies,renting display space,and paying for purchased items.A well-designed REA diagram would

Accepted Answer

A)  reflect minimum cardinalities of 1 for the relationship between Vendor and Cash Disbursement entities. 
B)  reflect the same number of 0 and 1 minimum cardinalities. 
C)  reflect more maximum cardinalities of M than of 1. 
D)  reflect maximum cardinalities of M for the relationship between Inventory and Purchase entities. 
A)  reflect minimum cardinalities of 1 for the relationship between Vendor and Cash Disbursement entities. 
B)  reflect the same number of 0 and 1 minimum cardinalities. 
C)  reflect more maximum cardinalities of M than of 1. 
D)  reflect maximum cardinalities of M for the relationship between Inventory and Purchase entities.

Question 14

Which of the following transactions is represented by the diagram below?

Accepted Answer

A)  Vendors send a bill for each inventory item purchased which is payable on receipt. 
B)  A single purchase of inventory is paid for with multiple payments. 
C)  Inventory vendors send a monthly bill for merchandise delivered. The seller does not accept or allow installment payments. 
D)  Some inventory purchases are paid for with multiple payments and some payments may apply to multiple purchases. 
A)  Vendors send a bill for each inventory item purchased which is payable on receipt. 
B)  A single purchase of inventory is paid for with multiple payments. 
C)  Inventory vendors send a monthly bill for merchandise delivered. The seller does not accept or allow installment payments. 
D)  Some inventory purchases are paid for with multiple payments and some payments may apply to multiple purchases.

Question 15

Which of the following is not one of the rules in creating an REA data model?

Accepted Answer

A)  Each event is linked to at least one resource that it affects. 
B)  Each event is linked to at least one other event. 
C)  Each event is linked to at least two participating agents. 
D)  All of the above are important rules. 
A)  Each event is linked to at least one resource that it affects. 
B)  Each event is linked to at least one other event. 
C)  Each event is linked to at least two participating agents. 
D)  All of the above are important rules.

Question 16

Describe the three basic rules that apply to the REA model pattern.

Accepted Answer

Each event is linked to at lea

Question 17

Identify the item below that would be classified as a resource by the REA data model.

Accepted Answer

A)  an IOU from a customer 
B)  the CFO 
C)  a customer sale 
D)  none of the above 
A)  an IOU from a customer 
B)  the CFO 
C)  a customer sale 
D)  none of the above

Question 18

Which of the following transactions is represented by the diagram below?

Accepted Answer

A)  Vendors send a bill for each inventory item purchased which is payable on receipt. 
B)  A single purchase of inventory is paid for with multiple payments. 
C)  Inventory vendors send a monthly bill for merchandise delivered. The seller does not accept or allow installment payments. 
D)  Some inventory purchases are paid for with multiple payments and some payments may apply to multiple purchases. 
A)  Vendors send a bill for each inventory item purchased which is payable on receipt. 
B)  A single purchase of inventory is paid for with multiple payments. 
C)  Inventory vendors send a monthly bill for merchandise delivered. The seller does not accept or allow installment payments. 
D)  Some inventory purchases are paid for with multiple payments and some payments may apply to multiple purchases.

Question 19

Assume that you are looking at a REA diagram that depicts only one event.Which of the following must be on the REA diagram?

Accepted Answer

A)  an external agent 
B)  an internal agent 
C)  both A and B 
D)  neither A nor B 
A)  an external agent 
B)  an internal agent 
C)  both A and B 
D)  neither A nor B

Question 20

Which of the following transactions is represented by the diagram below?

Accepted Answer

A)  Each sale is associated with a single order, and there is a time lag between the time an order is taken and delivery of the product. 
B)  Each sale can be comprised of multiple orders, and each order can be associated with multiple sales or no sales. 
C)  Each sale can be comprised of multiple orders, and each order can be associated with one or more sales. 
D)  Each sale is associated with a single order, and there is no time lag between the time an order is taken and delivery of the product. 
A)  Each sale is associated with a single order, and there is a time lag between the time an order is taken and delivery of the product. 
B)  Each sale can be comprised of multiple orders, and each order can be associated with multiple sales or no sales. 
C)  Each sale can be comprised of multiple orders, and each order can be associated with one or more sales. 
D)  Each sale is associated with a single order, and there is no time lag between the time an order is taken and delivery of the product.

Exam 17: Database Design Using the Rea Data Model

What is the minimum number of external agents that must participate in each REA event?

Identify the notation below that is not used to represent cardinality information.

In which stage(s)of the database design process is the completed data model used?

Which is a true statement about the REA data model?

Which of the following statements is true about the development of an REA model?

Which of the following transactions is represented by the diagram below?

What is the standard cardinality pattern for a relationship between an event and an agent?

What is the minimum number of agents that must participate in each REA event?

Which of the following transactions is represented by the diagram below?

Every person in the world has a birthdate,but no person has more than one birthdate.Thus,the cardinality that exists between birthdate and people is

The REA data model

Relationships that affect the quantity of a resource are sometimes referred to as ________ relationships.

Which of the following transactions is represented by the diagram below?

Which of the following is not one of the rules in creating an REA data model?

Describe the three basic rules that apply to the REA model pattern.

Identify the item below that would be classified as a resource by the REA data model.

Which of the following transactions is represented by the diagram below?

Assume that you are looking at a REA diagram that depicts only one event.Which of the following must be on the REA diagram?

Which of the following transactions is represented by the diagram below?

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

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters