Question 1

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) reduces the organization's liabilities. 
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) reduces the organization's liabilities.

Question 2

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 3

The "get" 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) increases the organization's liabilities. 
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) increases the organization's liabilities.

Question 4

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 5

Every person in the world can have more than one friend,and each person in the world can be a friend to more than one person.Thus,the cardinality that exists between friends and people 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 6

Which of the following statements is false regarding REA diagrams?

Accepted Answer

A) Each organization will have its own unique REA diagram. 
B) An REA diagram for a given organization will change over time. 
C) Data modeling and REA diagram development involve complex and repetitive processes. 
D) Redrawing an REA diagram several times during development is uncommon. 
A) Each organization will have its own unique REA diagram. 
B) An REA diagram for a given organization will change over time. 
C) Data modeling and REA diagram development involve complex and repetitive processes. 
D) Redrawing an REA diagram several times during development is uncommon.

Question 7

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

Accepted Answer

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

Question 8

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 9

Every company can have more than one banking relationships,and each bank can have a business relationship with more than one company.Thus,the cardinality that exists between company and bank 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

The choice of cardinalities is often arbitrary to reflect facts about the organization being modeled and its business practices.

Accepted Answer

A) True 
 B)False

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) is a graphical technique for portraying a database schema. 
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) is a graphical technique for portraying a database schema.

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

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.

Question 14

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 15

Describe the steps in developing an REA diagram.

Accepted Answer

Developing an REA diagram involves three

Question 16

What is Cardinalities?

Accepted Answer

Cardinalities describe the nat

Question 17

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 18

With regards to the database design process,accountants may provide the greatest value to their organization by participating in

Accepted Answer

A) implementation and conversion. 
B) data modeling. 
C) database operation and maintenance. 
D) system auditing. 
A) implementation and conversion. 
B) data modeling. 
C) database operation and maintenance. 
D) system auditing.

Question 19

Each event in an REA model will in most cases have at least one ________ agent and one ________ agent involved with the event.

Accepted Answer

A) internal; resource 
B) external; entity 
C) internal; employee 
D) internal; external 
A) internal; resource 
B) external; entity 
C) internal; employee 
D) internal; external

Question 20

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.

Exam 17: Database Design Using the Rea Data Model

The "give" event represents an activity which

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

The "get" event represents an activity which

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

Every person in the world can have more than one friend,and each person in the world can be a friend to more than one person.Thus,the cardinality that exists between friends and people is

Which of the following statements is false regarding REA diagrams?

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

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

Every company can have more than one banking relationships,and each bank can have a business relationship with more than one company.Thus,the cardinality that exists between company and bank is

The choice of cardinalities is often arbitrary to reflect facts about the organization being modeled and its business practices.

The REA data model

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

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

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

Describe the steps in developing an REA diagram.

What is Cardinalities?

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

With regards to the database design process,accountants may provide the greatest value to their organization by participating in

Each event in an REA model will in most cases have at least one ________ agent and one ________ agent involved with the event.

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

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

Each event in an REA model will in most cases have at least one agent and one agent involved with the event.