Question 1

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

Accepted Answer

Each event is linked to at lea...

Question 2

How many types of relationships are possible between entities?

Accepted Answer

A)  One.
B)  Two.
C)  Three.
D)  Four.E) B) and C)
F) All of the above

Question 3

Identify the item below that would be classified as an agent 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.E) All of the above
F) A) and D)

Question 4

Helge Autoparts sells new and refurbished auto parts exclusively to auto dealers.Helge purchases inventory from distributors at trade conventions.Each time Helge makes a purchase,the company records the suppliers name,address,date,specific items purchased,price paid for each,and the total amount spent.Helge later researches the inventory items to set the customer price.The company assigns an inventory number to each item purchased and records the customer price for each item.Helge buys price tags and display supplies from Alwin Incorporated,a company that sells them at all trade conventions.All inventory and supplies purchases are immediately paid for with cash or with checks from a bank account in Helge's name.All cash received from sales are also deposited to the same bank account.Several times a year Helge rents display space at dealer conventions.A deposit is always required,and the entire fee is due the day the convention starts.Helge records the deposit and final payment,along with the convention's name and address,in the same worksheet on which purchases of inventory and supplies are recorded.
Consider Helge's processes regarding the purchasing inventory and supplies,renting display space,and paying for purchased items.In a well-designed REA diagram,what entities would reflect economic duality?

Accepted Answer

A)  Purchases and Cash Disbursements
B)  Display Space Rental and Cash Disbursements
C)  Inventory and Purchases
D)  Cash and Cash DisbursementsE) A) and C)
F) A) and B)

Question 5

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

Accepted Answer

A)  
B)  
C)  
D)  E) B) and D)
F) A) and B)

Question 6

Which of the following statements is true about the development of an REA model?

Accepted Answer

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

Question 7

The maximum cardinality of any REA diagram relationship is

Accepted Answer

A)  zero or one.
B)  one or many.
C)  zero or many.
D)  many or none.E) A) and B)
F) A) and C) B

Question 8

Which of the following transactions 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.E) A) and B)
F) A) and C)

Question 9

Besides modeling entities as rectangles,there are no industry standards for entity-relationship diagrams.

Accepted Answer

A) True 
 B)False

Question 10

A relationship is diagrammed below using the [Min,Max] notation.Which of the diagrams below represents the same relationship using the "crow's feet" notation?

Accepted Answer

A)  
B)  
C)  
D)  E) B) and D)
F) None of the above

Question 11

Which of the following transactions 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.E) C) and D)
F) A) and D)

Question 12

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 term REA is an acronym that stands for resources,entities,and activities.E) A) and D)
F) A) and C)

Question 13

Which of the following transactions 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.E) A) and B)
F) A) and C)

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.E) All of the above
F) C) and D)

Question 15

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.E) B) and C)
F) A) and B)

Question 16

The process of defining a database so that it faithfully represents all aspects of the organization including its interactions with the external environment is called

Accepted Answer

A)  data modeling.
B)  data designing.
C)  data development.
D)  data definition.E) A) and D)
F) B) and C)

Question 17

REA models are usually depicted in which diagramming form?

Accepted Answer

A)  Entity-relationship diagrams.
B)  Economics-relationship diagrams.
C)  Entity-resource diagrams.
D)  Stock-flow diagrams.E) A) and C)
F) A) and B)

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.E) None of the above
F) A) and D)

Question 19

Describe data modeling.

Accepted Answer

Data modeling is the process of defining a database so that it faithfully represents all aspects of the organization,including its interaction with the external environment.

Question 20

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.E) B) and C)
F) A) and D) C

Exam 17: Database Design Using the Rea Data Model

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

Correct Answer
verified
Each event is linked to at lea...
View Answer

How many types of relationships are possible between entities?

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Which of the following statements is true about the development of an REA model?

Correct Answer
verified

The maximum cardinality of any REA diagram relationship is

Correct Answer
verified
B

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

Correct Answer
verified

Besides modeling entities as rectangles,there are no industry standards for entity-relationship diagrams.

Correct Answer
verified

A relationship is diagrammed below using the [Min,Max] notation.Which of the diagrams below represents the same relationship using the "crow's feet" notation?

Correct Answer
verified

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

Correct Answer
verified

Which is a true statement about the REA data model?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The process of defining a database so that it faithfully represents all aspects of the organization including its interactions with the external environment is called

Correct Answer
verified

REA models are usually depicted in which diagramming form?

Correct Answer
verified

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

Correct Answer
verified

Describe data modeling.

Correct Answer
verified
Data modeling is the process of defining a database so that it faithfully represents all aspects of the organization,including its interaction with the external environment.

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

Correct Answer
verified
C

Exam 17: Database Design Using the Rea Data Model

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

Correct AnswerverifiedEach event is linked to at lea...View AnswerShow Answer

How many types of relationships are possible between entities?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following statements is true about the development of an REA model?

Correct AnswerverifiedShow Answer

The maximum cardinality of any REA diagram relationship is

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

Besides modeling entities as rectangles,there are no industry standards for entity-relationship diagrams.

Correct AnswerverifiedShow Answer

A relationship is diagrammed below using the [Min,Max] notation.Which of the diagrams below represents the same relationship using the "crow's feet" notation?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which is a true statement about the REA data model?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The process of defining a database so that it faithfully represents all aspects of the organization including its interactions with the external environment is called

Correct AnswerverifiedShow Answer

REA models are usually depicted in which diagramming form?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Describe data modeling.

Correct AnswerverifiedData modeling is the process of defining a database so that it faithfully represents all aspects of the organization,including its interaction with the external environment.

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

Correct AnswerverifiedC

Correct Answer
verified
Each event is linked to at lea...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data modeling is the process of defining a database so that it faithfully represents all aspects of the organization,including its interaction with the external environment.

Correct Answer
verified
C