Question 1

Data modeling is an element of

Accepted Answer

A) systems analysis. 
B) conceptual design. 
C) system analysis and conceptual design. 
D) system analysis and physical design. 
A) systems analysis. 
B) conceptual design. 
C) system analysis and conceptual design. 
D) system analysis and physical design. C

Question 2

Explain specifically what is meant by the following statement: "Accountants can and should participate in all stages of the database design process."

Accepted Answer

Accountants are in a unique position within a business organization.They are intimately acquainted with the many business transactions that occur in an organization and they are knowledgeable about the policies and practices of the business itself as well as the environment within which it operates.The knowledge base and skill sets of the accountant should be put to good use in the development of database design to the fullest extent possible (although some accountants may not possess AIS coding and development skill sets).Consider that during the planning stage accountants provide some of the information used to evaluate the feasibility of the proposed project and they participate in making the decision itself.Accountants can identify user information needs and develop logical schema during the requirement analysis and design stages.Accountants can also help test the accuracy of the new database and application programs during the implementation stage of development.Accountants can also act as "subject matter experts" since they are knowledgeable users of the new system.They can also serve as managers of the system once it is up and running.

Question 3

An entity-relationship 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 C

Question 4

It is industry standard to model relationships as ________ in entity-relationship diagrams.

Accepted Answer

A) rectangles 
B) ovals 
C) diamonds 
D) There is no industry standard. 
A) rectangles 
B) ovals 
C) diamonds 
D) There is no industry standard.

Question 5

E-R diagrams can be used to represent the contents of any kind of database.

Accepted Answer

A) True 
 B)False

Question 6

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.A well-designed REA diagram would

Accepted Answer

A) reflect nine 1:N relationships. 
B) reflect two M:N relationships. 
C) reflect ten 1:N relationships. 
D) include two 1:1 relationships. 
A) reflect nine 1:N relationships. 
B) reflect two M:N relationships. 
C) reflect ten 1:N relationships. 
D) include two 1:1 relationships.

Question 7

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 8

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 9

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

Accepted Answer

A) A junkyard holds weekly sales where it sells its entire inventory. 
B) A shoe store sells products to consumers. 
C) A stay-at-home mom creates furniture for doll houses. When one piece is finished, she sells it on Amazon.com. 
D) Netflix sells movies to consumers through its online downloading service. 
A) A junkyard holds weekly sales where it sells its entire inventory. 
B) A shoe store sells products to consumers. 
C) A stay-at-home mom creates furniture for doll houses. When one piece is finished, she sells it on Amazon.com. 
D) Netflix sells movies to consumers through its online downloading service.

Question 10

In creating an entity-relationship diagram,________ is anything about which an organization wants to collect and store information.

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 11

Every person in the world has a birthdate,but no person has more than one birthdate.Thus,the cardinality that exists between birthdate 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 12

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

Question 13

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

Question 14

How many types of relationships are possible between entities?

Accepted Answer

A) One. 
B) Two. 
C) Three. 
D) Four. 
A) One. 
B) Two. 
C) Three. 
D) Four.

Question 15

Identify the item below that would be classified as an event 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. 
A) An IOU from a customer. 
B) The customer. 
C) A customer sale. 
D) A loan from a vendor.

Question 16

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

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

What is the minimum number of external agents that must participate in each REA event?

Accepted Answer

A) 0 
B) 2 
C) 1 
D) 3 
A) 0 
B) 2 
C) 1 
D) 3

Question 19

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 20

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.

Exam 17: Database Design Using the Rea Data Model

Data modeling is an element of

Explain specifically what is meant by the following statement: "Accountants can and should participate in all stages of the database design process."

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

It is industry standard to model relationships as ________ in entity-relationship diagrams.

E-R diagrams can be used to represent the contents of any kind of database.

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?

In creating an entity-relationship diagram,________ is anything about which an organization wants to collect and store information.

Every person in the world has a birthdate,but no person has more than one birthdate.Thus,the cardinality that exists between birthdate and people is

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

Which is a true statement about the REA data model?

How many types of relationships are possible between entities?

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

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

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

What is the minimum number of external agents that must participate in each REA event?

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

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

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

An entity-relationship diagram represents entities as and the relationships between them as lines and .