Question 1

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 2

What are the benefits of an integrated enterprise-wide data model?

Accepted Answer

One of the benefits of an integrated ent

Question 3

A relationship between Skills and Employees is typically modeled as M:N in an REA database model since

Accepted Answer

A)  one employee may possess many skills, and one skill may be possessed by more than one employee. 
B)  many employees possess skills, and many skills are possessed by employees. 
C)  employees can be trained to learn all skills, and all skills are possessed by at least one employee. 
D)  The relationship would be 1:N not M:N, because most employees are hired for a specific job that requires a specific skill, even though a specific job could be done by many employees. 
A)  one employee may possess many skills, and one skill may be possessed by more than one employee. 
B)  many employees possess skills, and many skills are possessed by employees. 
C)  employees can be trained to learn all skills, and all skills are possessed by at least one employee. 
D)  The relationship would be 1:N not M:N, because most employees are hired for a specific job that requires a specific skill, even though a specific job could be done by many employees.

Question 4

Using an REA database design,which is the most likely primary key for the Inventory-Request_Goods table?

Accepted Answer

A)  Product number 
B)  Product number - Purchase order number 
C)  Product number - Purchase requisition number 
D)  Purchase requisition number 
A)  Product number 
B)  Product number - Purchase order number 
C)  Product number - Purchase requisition number 
D)  Purchase requisition number

Question 5

Sales order number is most likely to be a foreign key in which entity of an expanded revenue cycle REA diagram?

Accepted Answer

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

Question 6

Which of the following diagrams represents the cardinality pairs in a situation where interviews are conducted individually,and job applicants are able to interview for one or more positions?

Accepted Answer

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

Question 7

The relationship between the Disburse Cash and Issue Stock events is modeled as being M:N for all except which of the following reasons?

Accepted Answer

A)  One dividend check could be paid to shareholders that purchased stock at different times. 
B)  Shareholders could receive several dividend checks over time. 
C)  Checks must be written to each shareholder for dividend payments. 
D)  Stock can be issued more than once over a period of time. 
A)  One dividend check could be paid to shareholders that purchased stock at different times. 
B)  Shareholders could receive several dividend checks over time. 
C)  Checks must be written to each shareholder for dividend payments. 
D)  Stock can be issued more than once over a period of time.

Question 8

The attributes of which type of entity would provide a way for the system to compare an employee's reimbursement request with the permissible range of the amount of reimbursement permitted?

Accepted Answer

A)  Resources 
B)  Events 
C)  Agents 
D)  Type 
A)  Resources 
B)  Events 
C)  Agents 
D)  Type

Question 9

Using an REA database design,which is the most likely primary key for the Pay for Goods table?

Accepted Answer

A)  Cash transaction number 
B)  Check number 
C)  Invoice number 
D)  Receiving report number, check number 
A)  Cash transaction number 
B)  Check number 
C)  Invoice number 
D)  Receiving report number, check number

Question 10

For a service business,the minimum cardinalities between Sales event and Inventory entity are most likely both 0 for all except which of the following reasons?

Accepted Answer

A)  Service businesses don't sell inventory, they only use inventory to perform services. 
B)  A sale doesn't have to include any inventory. 
C)  Inventory can exist that hasn't been part of a sale yet. 
D)  Some services only require labor. 
A)  Service businesses don't sell inventory, they only use inventory to perform services. 
B)  A sale doesn't have to include any inventory. 
C)  Inventory can exist that hasn't been part of a sale yet. 
D)  Some services only require labor.

Question 11

In which entity would information about depreciation formula(s)and assumption(s)be stored in an REA model?

Accepted Answer

A)  Resource 
B)  Event 
C)  Agent 
D)  Both A and B 
A)  Resource 
B)  Event 
C)  Agent 
D)  Both A and B

Question 12

Identify the business activity below that cannot be modeled using an REA diagram.

Accepted Answer

A)  purchase requisitions 
B)  rental transactions 
C)  intangible assets 
D)  All of the above can be modeled by an REA diagram. 
A)  purchase requisitions 
B)  rental transactions 
C)  intangible assets 
D)  All of the above can be modeled by an REA diagram.

Question 13

In addition to modeling Resources,Events,and Agents,identify the two additional concepts an organization will need to incorporate if it wishes to extend the REA to include information about firm policies.

Accepted Answer

A)  Type and Rules 
B)  Rules and Group 
C)  Group and Rules 
D)  None of the above 
A)  Type and Rules 
B)  Rules and Group 
C)  Group and Rules 
D)  None of the above

Question 14

Which of the following diagrams represents the cardinality pairs in a situation where many people apply for a specific position,and some of the applicants have applied for the position in the past?

Accepted Answer

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

Question 15

An organization that sells digital products,such as access to view online videos,does not need an inventory table in its database.

Accepted Answer

A) True 
 B)False

Question 16

In the table called Perform Machine Operations,which is the most likely primary key?

Accepted Answer

A)  Equipment Number 
B)  Job Operation Number 
C)  Machine Operation Number 
D)  Machine Operations List Number 
A)  Equipment Number 
B)  Job Operation Number 
C)  Machine Operation Number 
D)  Machine Operations List Number

Question 17

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 18

Which of the following diagrams represents the cardinality pairs in a situation where a specific production run results in a specific finished good,and a specific finished good is produced periodically?

Accepted Answer

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

Question 19

Which of the following accurately represents typical cardinalities for two entities in the HR/Payroll cycle?

Accepted Answer

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

Question 20

In which entity would an item's actual cost information most likely be maintained?

Accepted Answer

A)  Inventory entity 
B)  Order_Inventory entity 
C)  Inventory-Order_Inventory entity 
D)  none of the above 
A)  Inventory entity 
B)  Order_Inventory entity 
C)  Inventory-Order_Inventory entity 
D)  none of the above

Exam 19: Special Topics in Rea Modeling

Supplier number is least likely to be a foreign key in

What are the benefits of an integrated enterprise-wide data model?

A relationship between Skills and Employees is typically modeled as M:N in an REA database model since

Using an REA database design,which is the most likely primary key for the Inventory-Request_Goods table?

Sales order number is most likely to be a foreign key in which entity of an expanded revenue cycle REA diagram?

Which of the following diagrams represents the cardinality pairs in a situation where interviews are conducted individually,and job applicants are able to interview for one or more positions?

The relationship between the Disburse Cash and Issue Stock events is modeled as being M:N for all except which of the following reasons?

The attributes of which type of entity would provide a way for the system to compare an employee's reimbursement request with the permissible range of the amount of reimbursement permitted?

Using an REA database design,which is the most likely primary key for the Pay for Goods table?

For a service business,the minimum cardinalities between Sales event and Inventory entity are most likely both 0 for all except which of the following reasons?

In which entity would information about depreciation formula(s)and assumption(s)be stored in an REA model?

Identify the business activity below that cannot be modeled using an REA diagram.

In addition to modeling Resources,Events,and Agents,identify the two additional concepts an organization will need to incorporate if it wishes to extend the REA to include information about firm policies.

Which of the following diagrams represents the cardinality pairs in a situation where many people apply for a specific position,and some of the applicants have applied for the position in the past?

An organization that sells digital products,such as access to view online videos,does not need an inventory table in its database.

In the table called Perform Machine Operations,which is the most likely primary key?

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 specific production run results in a specific finished good,and a specific finished good is produced periodically?

Which of the following accurately represents typical cardinalities for two entities in the HR/Payroll cycle?

In which entity would an item's actual cost information most likely be maintained?

Accounting Information Systems: an Overview

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

Database Design Using the Rea Data Model

Implementing an Rea Model in a Relational Database

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters