Question 1

The first step in developing an REA diagram for a specific transaction cycle begins with identifying

Accepted Answer

A)  relevant events. 
B)  agents involved. 
C)  resources affected. 
D)  relationship cardinalities. 
A)  relevant events. 
B)  agents involved. 
C)  resources affected. 
D)  relationship cardinalities.

Question 2

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.

Question 3

Identify the notation often used to represent cardinality information.

Accepted Answer

A)  dotted lines 
B)  Greek characters 
C)  crow's feet 
D)  color coding 
A)  dotted lines 
B)  Greek characters 
C)  crow's feet 
D)  color coding

Question 4

A dental office employs three dentists and five dental hygienists.One of the dentists is a very recent dental school graduate and can't yet see patients on her own until she passes boards and obtains a license.Dentists perform all procedures personally,except for regular cleaning and x-rays,which are performed exclusively by dental hygienists.Three of the five dental hygienists perform only regular cleaning and x-rays.The other two hygienists each assist a specific dentist during procedures,as well as performing regular cleaning and x-rays.One of the hygienists will be assigned to the new dentist when she begins seeing patients.Hygienists usually 'shadow' other hygienists and dentists for two weeks prior to seeing patients.
Patients schedule appointments directly with dentists and hygienists,depending on the type of dental service needed.Patients do not have to choose a dentist until they need service other than routine cleaning or x-rays.Patients are assigned to a specific dental hygienist when they schedule their first appointment.The customer master file has 549 records.Diagram the agents described,relationships between agents,and the cardinality pairs for each relationship.

Accepted Answer

The answer of A dental office employs three dentists and...

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

Describe data modeling.

Accepted Answer

Data modeling is the process o

Question 8

Describe the steps in developing an REA diagram.

Accepted Answer

Developing an REA diagram involves three

Question 9

Explain specifically what is meant by the following statement: "Accountants can and should participate in all stages of the database design process."

Accepted Answer

Accountants are in a unique position wit

Question 10

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

Accepted Answer

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

Question 11

An REA diagram must link every event to at least one ________ and two ________.

Accepted Answer

A)  resource; agents 
B)  agent; resources 
C)  transaction; entities 
D)  resource; relationships 
A)  resource; agents 
B)  agent; resources 
C)  transaction; entities 
D)  resource; relationships

Question 12

In which stage(s)of the database design process does data modeling occur?

Accepted Answer

A)  only in the systems analysis stage 
B)  only in the 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 design stage 
C)  in both the systems analysis and design stages 
D)  neither the systems analysis nor the design stages

Question 13

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 14

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)  none of the above 
A)  one-to-one. 
B)  one-to-many. 
C)  many-to-many. 
D)  none of the above

Question 15

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.

Question 16

The "give" event represents an activity which

Accepted Answer

A)  includes a promise to engage in future economic exchanges. 
B)  increases the organization's stock of an economic resource. 
C)  reduces the organization's stock of a resource that has economic value. 
D)  none of the above 
A)  includes a promise to engage in future economic exchanges. 
B)  increases the organization's stock of an economic resource. 
C)  reduces the organization's stock of a resource that has economic value. 
D)  none of the above

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

The REA data model approach facilitates efficient operations by all the following except

Accepted Answer

A)  standardizing source document format. 
B)  identifying non-value added activities. 
C)  storing financial and nonfinancial data in the same database. 
D)  organizing data to simplify data retrieval and analysis. 
A)  standardizing source document format. 
B)  identifying non-value added activities. 
C)  storing financial and nonfinancial data in the same database. 
D)  organizing data to simplify data retrieval and analysis.

Question 20

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)

Exam 17: Database Design Using the Rea Data Model

The first step in developing an REA diagram for a specific transaction cycle begins with identifying

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

Identify the notation often used to represent cardinality information.

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

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

Describe data modeling.

Describe the steps in developing an REA diagram.

Explain specifically what is meant by the following statement: "Accountants can and should participate in all stages of the database design process."

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

An REA diagram must link every event to at least one ________ and two ________.

In which stage(s)of the database design process does data modeling occur?

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

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

The "give" event represents an activity which

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

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

The REA data model approach facilitates efficient operations by all the following except

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?

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

An REA diagram must link every event to at least one and two .