Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Data modeling is an element of

Accepted Answer

A) systems analysis. 
B) conceptual design. 
C) system analysis and conceptual design. 
D) system analysis and physical design. 
A) systems analysis. 
B) conceptual design. 
C) system analysis and conceptual design. 
D) system analysis and physical design.

Question 3

Identify the minimum cardinality of any REA diagram relationship.

Accepted Answer

A) 0 or 1. 
B) 0 or N. 
C) 1 or N. 
D) none of the above. 
A) 0 or 1. 
B) 0 or N. 
C) 1 or N. 
D) none of the above.

Question 4

A graphical depiction of a database's contents showing the various entities being modeled and the important relationships among them is called a(n)

Accepted Answer

A) REA diagram. 
B) data diagram. 
C) ERP diagram. 
D) ER diagram. 
A) REA diagram. 
B) data diagram. 
C) ERP diagram. 
D) ER diagram.

Question 5

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 6

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 7

In creating an entity-relationship diagram,________ is anything about which an organization wants to collect and store information.

Accepted Answer

A) a data model 
B) an entity 
C) a schema 
D) a tuple 
A) a data model 
B) an entity 
C) a schema 
D) a tuple

Question 8

In which stage(s)of the database design process should accountants participate?

Accepted Answer

A) the systems analysis stage 
B) the conceptual design stage 
C) the implementation and conversion stage 
D) in all of the stages above 
A) the systems analysis stage 
B) the conceptual design stage 
C) the implementation and conversion stage 
D) in all of the stages above

Question 9

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

Question 10

An entity-relationship diagram

Accepted Answer

A) can represent the contents of any database. 
B) is only used in conjunction with REA models. 
C) can show a limited number of entities and relationships. 
D) is used only to design new databases. 
A) can represent the contents of any database. 
B) is only used in conjunction with REA models. 
C) can show a limited number of entities and relationships. 
D) is used only to design new databases.

Question 11

________ includes carefully monitoring system performance and user satisfaction to determine the
Need for making system enhancements and modifications.

Accepted Answer

A) Operation and maintenance 
B) Conceptual design 
C) Physical design 
D) Implementation and conversion 
A) Operation and maintenance 
B) Conceptual design 
C) Physical design 
D) Implementation and conversion

Question 12

Identify the item below that would be classified as an event 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 13

Describe an REA data model.

Accepted Answer

The REA data model is a conceptual model

Question 14

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 15

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 16

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 17

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 18

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 19

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 20

Which of the following statements about REA modeling and REA diagrams is false?

Accepted Answer

A) REA is an acronym for Resources,Entities,and Agents. 
B) REA data modeling does not include traditional accounting elements such as ledgers,chart of accounts,debits and credits. 
C) REA data modeling could be referred to as an events-based model. 
D) REA diagrams must include at least two activities,which together represent a give-get economic exchange. 
A) REA is an acronym for Resources,Entities,and Agents. 
B) REA data modeling does not include traditional accounting elements such as ledgers,chart of accounts,debits and credits. 
C) REA data modeling could be referred to as an events-based model. 
D) REA diagrams must include at least two activities,which together represent a give-get economic exchange.

Exam 17: Database Design Using the Rea Data Model

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

Data modeling is an element of

Identify the minimum cardinality of any REA diagram relationship.

A graphical depiction of a database's contents showing the various entities being modeled and the important relationships among them is called a(n)

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

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

In creating an entity-relationship diagram,________ is anything about which an organization wants to collect and store information.

In which stage(s)of the database design process should accountants participate?

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

An entity-relationship diagram

________ includes carefully monitoring system performance and user satisfaction to determine the Need for making system enhancements and modifications.

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

Describe an REA data model.

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

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

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

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

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

Identify the notation often used to represent cardinality information.

Which of the following statements about REA modeling and REA diagrams is false?

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