Question 1

Since the same inventory items may be stored in several different warehouses,the maximum cardinality from Inventory to Warehouse is most likely ________.

Accepted Answer

A)  0 
B)  N 
C)  1 
D)  determined by the number of warehouses compared to the number of inventory items 
A)  0 
B)  N 
C)  1 
D)  determined by the number of warehouses compared to the number of inventory items

Question 2

Financial Institution number is most likely to be a foreign key in:

Accepted Answer

A)  Cash 
B)  Disburse Cash 
C)  Receive Inventory 
D)  Warehouse 
A)  Cash 
B)  Disburse Cash 
C)  Receive Inventory 
D)  Warehouse

Question 3

Which of the following accurately represents typical cardinalities for two entities in the finance cycle?

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D)

Question 4

Supplier number is least likely to be a foreign key in:

Accepted Answer

A)  Order Inventory 
B)  Disburse Cash 
C)  Receive Inventory 
D)  Warehouse 
A)  Order Inventory 
B)  Disburse Cash 
C)  Receive Inventory 
D)  Warehouse

Question 5

Relationships between resources and agents,such as Inventory and Supplier,reflect the best practice of identifying preferred and alternative suppliers for specific inventory items.Similar relationships between resources and employees can be used to model ________ and ________.

Accepted Answer

A)  cost; revenue 
B)  performance; behavior 
C)  responsibility; accountability 
D)  segregation of duties; internal control 
A)  cost; revenue 
B)  performance; behavior 
C)  responsibility; accountability 
D)  segregation of duties; internal control

Question 6

Which of the following diagrams represents the cardinality pairs in a situation where rented items must be returned intact,and several rented items could be returned at the same time?

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D)

Question 7

One of the benefits of an integrated enterprise-wide data model is that

Accepted Answer

A)  auditors can use it to guide the development of queries to validate the completeness and accuracy of transaction processing. 
B)  journals and ledgers will be more accurate than in a traditional AIS data model. 
C)  workers can understand information flows better. 
D)  all of the above are benefits of an integrated enterprise-wide data model. 
A)  auditors can use it to guide the development of queries to validate the completeness and accuracy of transaction processing. 
B)  journals and ledgers will be more accurate than in a traditional AIS data model. 
C)  workers can understand information flows better. 
D)  all of the above are benefits of an integrated enterprise-wide data model.

Question 8

There are four main events of interest included in a typical production cycle REA diagram.Which of the following is not one of them?

Accepted Answer

A)  Issuance of raw materials 
B)  Order raw materials 
C)  Use of labor in production 
D)  Use of machinery and equipment in production 
A)  Issuance of raw materials 
B)  Order raw materials 
C)  Use of labor in production 
D)  Use of machinery and equipment in production

Question 9

In an REA diagram for HRM/payroll cycles,the ________ entity is linked to almost every other entity in the diagram.

Accepted Answer

A)  Employee 
B)  Job title 
C)  Payroll 
D)  Worker I.D. 
A)  Employee 
B)  Job title 
C)  Payroll 
D)  Worker I.D.

Question 10

Data about actual raw materials used in production is stored in the ________ entity.

Accepted Answer

A)  Finished goods 
B)  Raw materials 
C)  Raw materials issuance 
D)  Work-in-process 
A)  Finished goods 
B)  Raw materials 
C)  Raw materials issuance 
D)  Work-in-process

Question 11

Employee number is most likely to be a foreign key in

Accepted Answer

A)  Perform Job Operations. 
B)  Perform Machine Operations. 
C)  Machine Operations List. 
D)  Work in Process. 
A)  Perform Job Operations. 
B)  Perform Machine Operations. 
C)  Machine Operations List. 
D)  Work in Process.

Question 12

Which of the following diagrams represents the cardinality pairs in a situation where a business that rents power tools (not all of which get rented)writes separate rental agreements for each tool,so renters don't have to return all items at the same time?

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D)

Question 13

The minimum cardinality from the Sales event to the Services entity is most likely 1 because

Accepted Answer

A)  every sale includes performing a service. 
B)  a service is only recorded once a sale has occurred. 
C)  only 1 service is provided for each sale. 
D)  the minimum cardinality would not be 1; it would most likely be 0. 
A)  every sale includes performing a service. 
B)  a service is only recorded once a sale has occurred. 
C)  only 1 service is provided for each sale. 
D)  the minimum cardinality would not be 1; it would most likely be 0.

Question 14

A dental office would likely model the relationships between the Sales event and both the Services and Supplies Resource entities as

Accepted Answer

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

Question 15

Give an example of an M:N Agent-Event relationship.

Accepted Answer

Some deliveries are so large that severa

Question 16

Why is the event Issue Debt often modeled as a separate event entity?

Accepted Answer

The event Issue Debt is a special kind o

Question 17

In an expanded revenue cycle REA diagram,sales order number is most likely to be a foreign key in

Accepted Answer

A)  Call on Customer. 
B)  Fill Customer Order. 
C)  Ship Order. 
D)  Take Customer Order. 
A)  Call on Customer. 
B)  Fill Customer Order. 
C)  Ship Order. 
D)  Take Customer Order.

Question 18

In an REA diagram for the HR/Payroll cycle,the relationship between Employees and Training is typicallty M:N for all except which of the following reasons?

Accepted Answer

A)  One employee may attend the same training event more than once. 
B)  Each employee may attend more than one training event. 
C)  Each training event may have more than one employee attend. 
D)  One training event may be offered more than once. 
A)  One employee may attend the same training event more than once. 
B)  Each employee may attend more than one training event. 
C)  Each training event may have more than one employee attend. 
D)  One training event may be offered more than once.

Question 19

Why might an REA diagram show relationships between agents?

Accepted Answer

Relationships between internal agents ma

Question 20

The Interview event stores detailed data about each job interview.Since hiring only happens once,but there may have been several interviews,Interview is linked to the Hire Employees event in a(n)________ relationship.

Accepted Answer

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

Exam 19: Special Topics in Rea Modeling

Since the same inventory items may be stored in several different warehouses,the maximum cardinality from Inventory to Warehouse is most likely ________.

Financial Institution number is most likely to be a foreign key in:

Which of the following accurately represents typical cardinalities for two entities in the finance cycle?

Supplier number is least likely to be a foreign key in:

Relationships between resources and agents,such as Inventory and Supplier,reflect the best practice of identifying preferred and alternative suppliers for specific inventory items.Similar relationships between resources and employees can be used to model ________ and ________.

Which of the following diagrams represents the cardinality pairs in a situation where rented items must be returned intact,and several rented items could be returned at the same time?

One of the benefits of an integrated enterprise-wide data model is that

There are four main events of interest included in a typical production cycle REA diagram.Which of the following is not one of them?

In an REA diagram for HRM/payroll cycles,the ________ entity is linked to almost every other entity in the diagram.

Data about actual raw materials used in production is stored in the ________ entity.

Employee number is most likely to be a foreign key in

Which of the following diagrams represents the cardinality pairs in a situation where a business that rents power tools (not all of which get rented)writes separate rental agreements for each tool,so renters don't have to return all items at the same time?

The minimum cardinality from the Sales event to the Services entity is most likely 1 because

A dental office would likely model the relationships between the Sales event and both the Services and Supplies Resource entities as

Give an example of an M:N Agent-Event relationship.

Why is the event Issue Debt often modeled as a separate event entity?

In an expanded revenue cycle REA diagram,sales order number is most likely to be a foreign key in

In an REA diagram for the HR/Payroll cycle,the relationship between Employees and Training is typicallty M:N for all except which of the following reasons?

Why might an REA diagram show relationships between agents?

The Interview event stores detailed data about each job interview.Since hiring only happens once,but there may have been several interviews,Interview is linked to the Hire Employees event in a(n)________ relationship.

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

The Rea Data Model

Implementing an Rea Model in a Relational Database

Introduction to Systems Development Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters

Relationships between resources and agents,such as Inventory and Supplier,reflect the best practice of identifying preferred and alternative suppliers for specific inventory items.Similar relationships between resources and employees can be used to model and .