Question 1

In a relational database,details about activities such as Cleaning,X-Rays,Fillings,Root Canals,Crowns,and Extractions would all be stored in which table?

Accepted Answer

A)  Services 
B)  Sales 
C)  Inventory 
D)  Those activities would be stored as part of a relationship, not a table. 
A)  Services 
B)  Sales 
C)  Inventory 
D)  Those activities would be stored as part of a relationship, not a table.

Question 2

In an expanded revenue cycle REA diagram,customer number is least likely to be a foreign key in

Accepted Answer

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

Question 3

Which of the following diagrams represents the cardinality pairs in a situation where a finished product requires one or more machine operations,and machines usage is recorded to specific production runs?

Accepted Answer

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

Question 4

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

Accepted Answer

A)  Inventory-Request_Inventory 
B)  Receive Inventory 
C)  Supplier 
D)  Warehouse 
A)  Inventory-Request_Inventory 
B)  Receive Inventory 
C)  Supplier 
D)  Warehouse

Question 5

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

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 a specific skill is taught at training sessions held periodically,but training is not offered for all skills?

Accepted Answer

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

Question 7

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 8

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 9

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

Accepted Answer

A)  Customers. 
B)  Fill Customer Order. 
C)  Ship Order. 
D)  Take Customer Order 
A)  Customers. 
B)  Fill Customer Order. 
C)  Ship Order. 
D)  Take Customer Order

Question 10

The temporal difference between Request Inventory and Order Inventory is reflected by the

Accepted Answer

A)  Request Inventory minimum cardinality of 1. 
B)  Request Inventory maximum of N. 
C)  Order Inventory maximum of N. 
D)  Order Inventory minimum of 0. 
A)  Request Inventory minimum cardinality of 1. 
B)  Request Inventory maximum of N. 
C)  Order Inventory maximum of N. 
D)  Order Inventory minimum of 0.

Question 11

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 12

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 13

M:N agent-event relationships occur whenever an activity is performed by ________ employee and management wants to retain the ability to monitor ________ performance.

Accepted Answer

A)  more than one; group 
B)  more than one; individual 
C)  one; group 
D)  one; individual 
A)  more than one; group 
B)  more than one; individual 
C)  one; group 
D)  one; individual

Question 14

Concerning cost data,which of the following is false?

Accepted Answer

A)  Cost information is stored in several tables. 
B)  Standard cost is stored as an attribute of the Inventory table because it is the same for all units of a given inventory item for a fiscal year. 
C)  In contrast, the actual cost of inventory is stored in a relationship table because prices can vary over time. 
D)  Actual cost can be stored as an attribute of the Inventory table for organizations that value inventory based on the most recent amount paid. 
A)  Cost information is stored in several tables. 
B)  Standard cost is stored as an attribute of the Inventory table because it is the same for all units of a given inventory item for a fiscal year. 
C)  In contrast, the actual cost of inventory is stored in a relationship table because prices can vary over time. 
D)  Actual cost can be stored as an attribute of the Inventory table for organizations that value inventory based on the most recent amount paid.

Question 15

Why might an REA diagram show relationships between resources and agents?

Accepted Answer

For example,the REA model for the expend

Question 16

Which of the following diagrams represents the cardinality pairs in a situation where goods don't have to be requisitioned,but if they are,requisitions are approved and processed before purchase orders are issued?

Accepted Answer

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

Question 17

Which of the following diagrams represents the cardinality pairs in a situation where interviews are conducted individually and potential employees are able to interview for more than one position,or the same position at different times?

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

Describe the relationships between Recruiting event and Skills,and between Recruiting event and Job Applicants.

Accepted Answer

The Recruiting event entity stores data

Question 20

In the human resources REA model,the relationship between Skills and Employees is typically modeled as M:N because

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.

Exam 19: Special Topics in Rea Modeling

In a relational database,details about activities such as Cleaning,X-Rays,Fillings,Root Canals,Crowns,and Extractions would all be stored in which table?

In an expanded revenue cycle REA diagram,customer number is least likely to be a foreign key in

Which of the following diagrams represents the cardinality pairs in a situation where a finished product requires one or more machine operations,and machines usage is recorded to specific production runs?

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

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

Which of the following diagrams represents the cardinality pairs in a situation where a specific skill is taught at training sessions held periodically,but training is not offered for all skills?

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?

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

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

The temporal difference between Request Inventory and Order Inventory is reflected by the

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?

M:N agent-event relationships occur whenever an activity is performed by ________ employee and management wants to retain the ability to monitor ________ performance.

Concerning cost data,which of the following is false?

Why might an REA diagram show relationships between resources and agents?

Which of the following diagrams represents the cardinality pairs in a situation where goods don't have to be requisitioned,but if they are,requisitions are approved and processed before purchase orders are issued?

Which of the following diagrams represents the cardinality pairs in a situation where interviews are conducted individually and potential employees are able to interview for more than one position,or the same position at different times?

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

Describe the relationships between Recruiting event and Skills,and between Recruiting event and Job Applicants.

In the human resources REA model,the relationship between Skills and Employees is typically modeled as M:N because

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

M:N agent-event relationships occur whenever an activity is performed by employee and management wants to retain the ability to monitor performance.