Question 1

The minimum cardinality of a relationship in an REA diagram can be either

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 A

Question 2

On an entity-relationship (E-R)diagram,anything about which an 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. B

Question 3

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. C

Question 4

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

Accepted Answer

A)  data flow 
B)  flowchart 
C)  entity-relationship 
D)  REA 
A)  data flow 
B)  flowchart 
C)  entity-relationship 
D)  REA

Question 5

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

Accepted Answer

A)  An automobile salvage business holds weekly auctions at which it sells its entire inventory. 
B)  A grocery store sells products to consumers. 
C)  A hobbyist restores antique cars. When a car is finished, she sells it on eBay. 
D)  A firm sells movies to consumers through an online downloading service. 
A)  An automobile salvage business holds weekly auctions at which it sells its entire inventory. 
B)  A grocery store sells products to consumers. 
C)  A hobbyist restores antique cars. When a car is finished, she sells it on eBay. 
D)  A firm sells movies to consumers through an online downloading service.

Question 6

Describe an REA data model.

Accepted Answer

The REA data model is a conceptual model

Question 7

What is the standard cardinality pattern for a relationship between an event and an agent?

Accepted Answer

A)  1:1 
B)  0:1 
C)  0:N 
D)  1:N 
A)  1:1 
B)  0:1 
C)  0:N 
D)  1:N

Question 8

Describe data modeling.

Accepted Answer

Data modeling is the process o

Question 9

Cosgrove Art & Antiques sells unique art and antiques exclusively at antique shows.Cosgrove purchases inventory from individuals and other dealers at garage sales,flea markets,antique malls,and estate sales.Each time Cosgrove makes a purchase,she records the person's name,address,date,specific items purchased and price paid,and total amount spent.Later at home,Cosgrove cleans,researches and prices the inventory items.She assigns an inventory number to each item and records the "asking" price.Cosgrove buys price tags and display supplies from a company that sells at flea market and antique shows.All inventory and supplies purchases are paid immediately with cash,or with checks from a bank account in the business' name,to which sales are also deposited.Several times a year Cosgrove rents a booth at an antique show.A deposit is always required,with the balance due at the start of the show.Cosgrove records the deposit and final payment,along with the show organizer's name and address,in the same worksheet on which purchases of inventory and supplies are recorded. A well-planned and correctly drawn REA diagram for Cosgrove Art & Antiques,related to purchasing inventory and supplies,renting booths,and paying for all items,what entities would reflect economic duality?

Accepted Answer

A)  Purchases and Cash Disbursements 
B)  Booth Rental and Cash Disbursements 
C)  Inventory and Purchases 
D)  Cash and Cash Disbursements 
A)  Purchases and Cash Disbursements 
B)  Booth Rental and Cash Disbursements 
C)  Inventory and Purchases 
D)  Cash and Cash Disbursements

Question 10

Describe the three basic rules that apply to the REA model pattern.

Accepted Answer

Each event is linked to at lea

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

Cosgrove Art & Antiques sells unique art and antiques exclusively at antique shows.Cosgrove purchases inventory from individuals and other dealers at garage sales,flea markets,antique malls,and estate sales.Each time Cosgrove makes a purchase,she records the person's name,address,date,specific items purchased and price paid,and total amount spent.Later at home,Cosgrove cleans,researches and prices the inventory items.She assigns an inventory number to each item and records the "asking" price.Cosgrove buys price tags and display supplies from a company that sells at flea market and antique shows.All inventory and supplies purchases are paid immediately with cash,or with checks from a bank account in the business' name,to which sales are also deposited.Several times a year Cosgrove rents a booth at an antique show.A deposit is always required,with the balance due at the start of the show.Cosgrove records the deposit and final payment,along with the show organizer's name and address,in the same worksheet on which purchases of inventory and supplies are recorded. A well-planned and correctly drawn REA diagram for Cosgrove Art & Antiques,related to purchasing inventory and supplies,renting booths,and paying for all items,would

Accepted Answer

A)  include eight unique entities. 
B)  include nine unique entities. 
C)  include seven unique entities. 
D)  include ten unique entities. 
A)  include eight unique entities. 
B)  include nine unique entities. 
C)  include seven unique entities. 
D)  include ten unique entities.

Question 13

An entity-relationship (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 14

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

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.

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 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 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 19

An entity-relationship (E-R)diagram

Accepted Answer

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

Question 20

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

The minimum cardinality of a relationship in an REA diagram can be either

On an entity-relationship (E-R)diagram,anything about which an organization wants to collect and store information is called

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

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

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

Describe an REA data model.

What is the standard cardinality pattern for a relationship between an event and an agent?

Describe data modeling.

Describe the three basic rules that apply to the REA model pattern.

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

An entity-relationship (E-R)diagram represents entities as and the relationships between them as lines and .

The "get" event represents an activity which

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

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

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

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

An entity-relationship (E-R)diagram

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

Accounting Information Systems: an Overview

Overview of Transaction Processing and Erp Systems

Systems Documentation Techniques

Relational Databases

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Information Systems Controls for System Reliability Part 1: Information Security

Information Systems Controls for Systems Reliability Part 2: Confidentiality and Privacy

Information Systems Controls for Systems Reliability Part 3: Processing Integrity and Availability

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 Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters

Exam 17: The Rea Data Model

The minimum cardinality of a relationship in an REA diagram can be either

On an entity-relationship (E-R)diagram,anything about which an organization wants to collect and store information is called

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

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

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

Describe an REA data model.

What is the standard cardinality pattern for a relationship between an event and an agent?

Describe data modeling.

Describe the three basic rules that apply to the REA model pattern.

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

An entity-relationship (E-R)diagram represents entities as ________ and the relationships between them as lines and ________.

The "get" event represents an activity which

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

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

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

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

An entity-relationship (E-R)diagram

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

Accounting Information Systems: an Overview

Overview of Transaction Processing and Erp Systems

Systems Documentation Techniques

Relational Databases

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Information Systems Controls for System Reliability Part 1: Information Security

Information Systems Controls for Systems Reliability Part 2: Confidentiality and Privacy

Information Systems Controls for Systems Reliability Part 3: Processing Integrity and Availability

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 Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters

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

An entity-relationship (E-R)diagram represents entities as and the relationships between them as lines and .

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