Question 1

What is an REA data model?

Accepted Answer

The REA data model is a conceptual model

Question 2

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 3

What does the acronym REA mean?

Accepted Answer

A) resources,events,agents 
B) resources,entities,agents 
C) relations,events,agents 
D) relations,entities,agents 
A) resources,events,agents 
B) resources,entities,agents 
C) relations,events,agents 
D) relations,entities,agents

Question 4

Developing an REA diagram for a specific transaction cycle consists of steps.The third step involves

Accepted Answer

A) Identifying events 
B) Identifying agents 
C) Identifying resources 
D) Identifying cardinalities of each relationship 
A) Identifying events 
B) Identifying agents 
C) Identifying resources 
D) Identifying cardinalities of each relationship

Question 5

Which type of transaction 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 6

An example of an event is

Accepted Answer

A) employees 
B) customers 
C) sales 
D) cash 
A) employees 
B) customers 
C) sales 
D) cash

Question 7

Which type of transaction 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 8

Which type of transaction 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 multiple 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 multiple 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 9

Which type of transaction 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 10

An E-R diagram represents entities as __________ and the relationships between them as lines and __________.

Accepted Answer

A) circles; squares 
B) squares; diamonds 
C) rectangles; diamonds 
D) rectangles; circles 
A) circles; squares 
B) squares; diamonds 
C) rectangles; diamonds 
D) rectangles; circles

Question 11

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 12

There are five basic stages in the database design process.The step which includes developing the conceptual-,external-,and internal-level schema into the actual database structures is known as

Accepted Answer

A) stage one. 
B) stage two. 
C) stage three. 
D) stage four. 
A) stage one. 
B) stage two. 
C) stage three. 
D) stage four.

Question 13

Concerning the development of an REA model,which of the following statements is true?

Accepted Answer

A) Events that pertain to the entry of data are included in the REA model. 
B) The objective is to model the basic value-chain activity. 
C) REA diagrams model individual transactions and data collections. 
D) Information retrieval events are modeled as events in the REA model. 
A) Events that pertain to the entry of data are included in the REA model. 
B) The objective is to model the basic value-chain activity. 
C) REA diagrams model individual transactions and data collections. 
D) Information retrieval events are modeled as events in the REA model.

Question 14

Define cardinality.

Accepted Answer

The cardinality of the relationship indi

Question 15

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 16

Which of the following is not one of the five stages of database design?

Accepted Answer

A) systems analysis 
B) conceptual design 
C) data modeling 
D) implementation 
A) systems analysis 
B) conceptual design 
C) data modeling 
D) implementation

Question 17

An entity-relationship diagram (E-R)is useful because it shows the various entities being modeled and the important relationships among them.Anything about which the organization wants to collect and store information is called

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 18

Developing an REA diagram for a specific transaction cycle consists of steps.The first step involves

Accepted Answer

A) Identifying events 
B) Identifying agents 
C) Identifying resources 
D) Identifying cardinality 
A) Identifying events 
B) Identifying agents 
C) Identifying resources 
D) Identifying cardinality

Question 19

An E-R diagram

Accepted Answer

A) only depicts the contents of a database. 
B) only graphically models an organization. 
C) only defines a database so that it represents all aspects of the organization. 
D) depicts both the contents of a database and graphically models an organization. 
A) only depicts the contents of a database. 
B) only graphically models an organization. 
C) only defines a database so that it represents all aspects of the organization. 
D) depicts both the contents of a database and graphically models an organization.

Question 20

List the five stages in the database design process.

Accepted Answer

Systems Analysis,conceptual de

What is an REA data model?

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

What does the acronym REA mean?

Developing an REA diagram for a specific transaction cycle consists of steps.The third step involves

Which type of transaction is represented by the diagram below?

An example of an event is

Which type of transaction is represented by the diagram below?

Which type of transaction is represented by the diagram below?

Which type of transaction is represented by the diagram below?

An E-R diagram represents entities as and the relationships between them as lines and .

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

There are five basic stages in the database design process.The step which includes developing the conceptual-,external-,and internal-level schema into the actual database structures is known as

Concerning the development of an REA model,which of the following statements is true?

Define cardinality.

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

Which of the following is not one of the five stages of database design?

An entity-relationship diagram (E-R)is useful because it shows the various entities being modeled and the important relationships among them.Anything about which the organization wants to collect and store information is called

Developing an REA diagram for a specific transaction cycle consists of steps.The first step involves

An E-R diagram

List the five stages in the database design process.

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

What is an REA data model?

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

What does the acronym REA mean?

Developing an REA diagram for a specific transaction cycle consists of steps.The third step involves

Which type of transaction is represented by the diagram below?

An example of an event is

Which type of transaction is represented by the diagram below?

Which type of transaction is represented by the diagram below?

Which type of transaction is represented by the diagram below?

An E-R diagram represents entities as __________ and the relationships between them as lines and __________.

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

There are five basic stages in the database design process.The step which includes developing the conceptual-,external-,and internal-level schema into the actual database structures is known as

Concerning the development of an REA model,which of the following statements is true?

Define cardinality.

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

Which of the following is not one of the five stages of database design?

An entity-relationship diagram (E-R)is useful because it shows the various entities being modeled and the important relationships among them.Anything about which the organization wants to collect and store information is called

Developing an REA diagram for a specific transaction cycle consists of steps.The first step involves

An E-R diagram

List the five stages in the database design process.

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

An E-R diagram represents entities as and the relationships between them as lines and .