Question 1

Data modeling is an element of

Accepted Answer

A) Systems analysis 
B) Conceptual design 
C) Both A and B 
D) None of the above 
A) Systems analysis 
B) Conceptual design 
C) Both A and B 
D) None of the above

Question 2

Which type of transaction is represented by the diagram below?

Accepted Answer

A) Cash and carry consumer retail sales 
B) Consumer retail sales paid in installments to the seller 
C) Business to business sales of nondurable goods 
D) Business that allows customers to carry a balance and make installment payments 
A) Cash and carry consumer retail sales 
B) Consumer retail sales paid in installments to the seller 
C) Business to business sales of nondurable goods 
D) Business that allows customers to carry a balance and make installment payments

Question 3

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 4

The REA data model

Accepted Answer

A) Is used in many areas of business and science. 
B) Was developed solely 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 solely for use in designing accounting information systems. 
C) Classifies data into relationships,entities and accounts. 
D) All of the above.

Question 5

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) 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 6

Accountants should be involved in __________ aspect(s)of the database design process.

Accepted Answer

A) only the physical modeling 
B) all 
C) only the data flow diagram 
D) only the requirements analysis 
A) only the physical modeling 
B) all 
C) only the data flow diagram 
D) only the requirements analysis

Question 7

Concerning cardinality,which of the following is true?

Accepted Answer

A) The three basic types of relationship between entities are identified by their minimum cardinality. 
B) The choice of cardinalities is arbitrary. 
C) The minimum cardinality is generally given last. 
D) Cardinality information is the final step in drawing an REA diagram 
A) The three basic types of relationship between entities are identified by their minimum cardinality. 
B) The choice of cardinalities is arbitrary. 
C) The minimum cardinality is generally given last. 
D) Cardinality information is the final step in drawing an REA diagram

Question 8

Concerning REA diagrams,which of the following is false?

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 9

Which of the following is not one of the rules that describe how the three types of entities should relate to one another in 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 10

Comment on the statement,"Accountants can and should participate in all stages of the database design process."

Accepted Answer

Accountants are in a unique position wit

Question 11

A(n)__________ diagram graphically depicts a database's contents by showing entities and relationships.

Accepted Answer

A) DFD 
B) flowchart 
C) E-R 
D) REA 
A) DFD 
B) flowchart 
C) E-R 
D) REA

Question 12

How many types of relationships are possible between entities?

Accepted Answer

A) one 
B) two 
C) three 
D) an infinite number 
A) one 
B) two 
C) three 
D) an infinite number

Question 13

Concerning cardinality,which of the following is false?

Accepted Answer

A) Cardinalities describe the nature of the relationship between two entities. 
B) No universal standard exists for representing information about cardinalities in REA diagrams. 
C) The minimum cardinality can be zero. 
D) The maximum cardinality can be zero. 
A) Cardinalities describe the nature of the relationship between two entities. 
B) No universal standard exists for representing information about cardinalities in REA diagrams. 
C) The minimum cardinality can be zero. 
D) The maximum cardinality can be zero.

Question 14

Accountants may provide the greatest value to their organization by taking responsibility for data modeling.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 of database design 
D) neither the systems analysis nor the design stages of database design 
A) only in the systems analysis stage 
B) only in the design stage 
C) in both the systems analysis and design stages of database design 
D) neither the systems analysis nor the design stages of database design

Question 15

In an REA diagram,the pair of numbers next to each entity represents the cardinalities for the entity.The first number in the pair is known as

Accepted Answer

A) the minimum cardinality. 
B) the maximum cardinality. 
C) the x axis cardinality. 
D) the y axis cardinality. 
A) the minimum cardinality. 
B) the maximum cardinality. 
C) the x axis cardinality. 
D) the y axis cardinality.

Question 16

The REA data model supports both __________ and __________ types of data.

Accepted Answer

A) financial; nonfinancial 
B) logical; physical 
C) planning; control 
D) traditional; nontraditional 
A) financial; nonfinancial 
B) logical; physical 
C) planning; control 
D) traditional; nontraditional

Question 17

Name and describe the three parts of the REA data model.

Accepted Answer

REA stands for resources,events,and agen

Question 18

Nonfinancial information should be collected because

Accepted Answer

A) it may indicate events that may affect resources. 
B) it can be used to plan other activities. 
C) it can be used in transaction processing. 
D) both A and B 
A) it may indicate events that may affect resources. 
B) it can be used to plan other activities. 
C) it can be used in transaction processing. 
D) both A and B

Question 19

What are the three steps in developing an REA diagram?

Accepted Answer

Developing an REA diagram involves three

Question 20

What is data modeling?

Accepted Answer

Data modeling is the process o

Data modeling is an element of

Which type of transaction is represented by the diagram below?

Which is a true statement about the REA data model?

The REA data model

The "get" event represents an activity which

Accountants should be involved in __________ aspect(s)of the database design process.

Concerning cardinality,which of the following is true?

Concerning REA diagrams,which of the following is false?

Which of the following is not one of the rules that describe how the three types of entities should relate to one another in an REA data model?

Comment on the statement,"Accountants can and should participate in all stages of the database design process."

A(n)__________ diagram graphically depicts a database's contents by showing entities and relationships.

How many types of relationships are possible between entities?

Concerning cardinality,which of the following is false?

Accountants may provide the greatest value to their organization by taking responsibility for data modeling.In which stage(s)of the database design process does data modeling occur?

In an REA diagram,the pair of numbers next to each entity represents the cardinalities for the entity.The first number in the pair is known as

The REA data model supports both and types of data.

Name and describe the three parts of the REA data model.

Nonfinancial information should be collected because

What are the three steps in developing an REA diagram?

What is data modeling?

Accounting Information Systems

Overview of Business Processes

Systems Development and Documentation Techniques

Relational Databases

Computer Fraud and Security

Control and Accounting Information Systems

Infromation System Controls for Systems Reliability

Auditing Computer-Based Information Systems

Auditing Computer-Based Informtion Systems

The Revenue Cycle: Sales an Cash Collections

The Expenditure Cycle: Purchasing and Cash Disbursements

The Production Cycle

The Human Resources Managementpayroll 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

Exam 15: Data Modeling and Database Design

Data modeling is an element of

Which type of transaction is represented by the diagram below?

Which is a true statement about the REA data model?

The REA data model

The "get" event represents an activity which

Accountants should be involved in __________ aspect(s)of the database design process.

Concerning cardinality,which of the following is true?

Concerning REA diagrams,which of the following is false?

Which of the following is not one of the rules that describe how the three types of entities should relate to one another in an REA data model?

Comment on the statement,"Accountants can and should participate in all stages of the database design process."

A(n)__________ diagram graphically depicts a database's contents by showing entities and relationships.

How many types of relationships are possible between entities?

Concerning cardinality,which of the following is false?

Accountants may provide the greatest value to their organization by taking responsibility for data modeling.In which stage(s)of the database design process does data modeling occur?

In an REA diagram,the pair of numbers next to each entity represents the cardinalities for the entity.The first number in the pair is known as

The REA data model supports both __________ and __________ types of data.

Name and describe the three parts of the REA data model.

Nonfinancial information should be collected because

What are the three steps in developing an REA diagram?

What is data modeling?

Accounting Information Systems

Overview of Business Processes

Systems Development and Documentation Techniques

Relational Databases

Computer Fraud and Security

Control and Accounting Information Systems

Infromation System Controls for Systems Reliability

Auditing Computer-Based Information Systems

Auditing Computer-Based Informtion Systems

The Revenue Cycle: Sales an Cash Collections

The Expenditure Cycle: Purchasing and Cash Disbursements

The Production Cycle

The Human Resources Managementpayroll 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

The REA data model supports both and types of data.