Question 1

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

Accepted Answer

A) A junkyard holds weekly sales where it sells its entire inventory. 
B) A shoe store sells products to consumers. 
C) A stay-at-home mom creates furniture for doll houses. When one piece is finished, she sells it on Amazon.com. 
D) Netflix sells movies to consumers through its online downloading service. 
A) A junkyard holds weekly sales where it sells its entire inventory. 
B) A shoe store sells products to consumers. 
C) A stay-at-home mom creates furniture for doll houses. When one piece is finished, she sells it on Amazon.com. 
D) Netflix sells movies to consumers through its online downloading service.

Question 2

Identify the item below that would be classified as an agent by the REA data model.

Accepted Answer

A) An IOU from a customer. 
B) The customer. 
C) A customer sale. 
D) A loan from a vendor. 
A) An IOU from a customer. 
B) The customer. 
C) A customer sale. 
D) A loan from a vendor.

Question 3

It is industry standard to model entities as rectangles on entity-relationship diagrams.

Accepted Answer

A) True 
 B)False

Question 4

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 customer. 
C) A customer sale. 
D) A loan from a vendor. 
A) An IOU from a customer. 
B) The customer. 
C) A customer sale. 
D) A loan from a vendor.

Question 5

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

Accepted Answer

A) A junkyard holds weekly sales where it sells its entire inventory. 
B) A shoe store sells products to consumers. 
C) A stay-at-home mom creates furniture for doll houses. When one piece is finished, she sells it on Amazon.com. 
D) Netflix sells movies to consumers through its online downloading service. 
A) A junkyard holds weekly sales where it sells its entire inventory. 
B) A shoe store sells products to consumers. 
C) A stay-at-home mom creates furniture for doll houses. When one piece is finished, she sells it on Amazon.com. 
D) Netflix sells movies to consumers through its online downloading service.

Question 6

The maximum cardinality of any REA diagram relationship is

Accepted Answer

A) zero or one. 
B) one or many. 
C) zero or many. 
D) many or none. 
A) zero or one. 
B) one or many. 
C) zero or many. 
D) many or none.

Question 7

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 8

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 9

Every citizen in the United States has one social security number,but no two citizens have the same social security number.Thus,the cardinality that exists between social security numbers and citizens is

Accepted Answer

A) one-to-one. 
B) one-to-many. 
C) many-to-many. 
D) many-to-none. 
A) one-to-one. 
B) one-to-many. 
C) many-to-many. 
D) many-to-none.

Question 10

Describe data modeling.

Accepted Answer

Data modeling is the process o

Question 11

A relationship is diagrammed below using the [Min,Max] notation.Which of the diagrams below represents the same relationship using the "crow's feet" notation?

Accepted Answer

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

Question 12

Explain how an AIS system can be viewed as a set of "give-to-get" exchanges.

Accepted Answer

An AIS system can be viewed as a set of

Question 13

Which of the following graphical symbols represents a minimum cardinality of one and a maximum cardinality of one?

Accepted Answer

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

Question 14

________ consists of translating the internal-level schema into the actual database structures that will be implemented in the new system.

Accepted Answer

A) Systems analysis 
B) Conceptual design 
C) Physical design 
D) Implementation and conversion 
A) Systems analysis 
B) Conceptual design 
C) Physical design 
D) Implementation and conversion

Question 15

Prescott Dolls sells porcelain dolls exclusively at antique shows.Prescott Dolls purchases inventory from individuals at garage sales,flea markets,antique malls,and estate sales.Each time Dahlia Prescott (the owner)makes a purchase,she records the person's name,address,date,specific items purchased and price paid,and total amount spent.Later at home,Dahlia cleans,researches and prices the inventory for sale to customers.She assigns an inventory number to each item and records the "asking" price.Dahlia buys price tags and display supplies from a company that sells at flea market and antique shows.All inventory and supplies purchases are immediately paid for using cash or with company checks from a bank account in Prescott Doll's name.Cash received from customer sales are also deposited in this account.Three times a year,Dahlia rents a booth at antique shows.A deposit is always required,with the balance due at the start of the show.Dahlia records the deposit and final payment,along with the show organizer's name and address,in the same worksheet on which purchases of inventory and supplies are recorded.
Draw an REA diagram for Prescott Dolls,related to purchasing inventory and supplies,renting booths,and paying for all items.

Accepted Answer

The answer of Prescott Dolls sells porcelain dolls exclusively at...

Question 16

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 17

Besides modeling entities as rectangles,there are no industry standards for entity-relationship diagrams.

Accepted Answer

A) True 
 B)False

Question 18

Define minimum and maximum cardinalities.

Accepted Answer

A minimum cardinality indicates the numb

Question 19

Which of the following graphical symbols represents a minimum cardinality of zero and a maximum cardinality of many?

Accepted Answer

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

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

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

Identify the item below that would be classified as an agent by the REA data model.

It is industry standard to model entities as rectangles on entity-relationship diagrams.

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?

The maximum cardinality of any REA diagram relationship is

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?

Every citizen in the United States has one social security number,but no two citizens have the same social security number.Thus,the cardinality that exists between social security numbers and citizens is

Describe data modeling.

A relationship is diagrammed below using the [Min,Max] notation.Which of the diagrams below represents the same relationship using the "crow's feet" notation?

Explain how an AIS system can be viewed as a set of "give-to-get" exchanges.

Which of the following graphical symbols represents a minimum cardinality of one and a maximum cardinality of one?

________ consists of translating the internal-level schema into the actual database structures that will be implemented in the new system.

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

Besides modeling entities as rectangles,there are no industry standards for entity-relationship diagrams.

Define minimum and maximum cardinalities.

Which of the following graphical symbols represents a minimum cardinality of zero and a maximum cardinality of many?

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

Conceptual Foundations of Accounting Information Systems

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