Question 1

Which of the following diagrams represents the cardinality pairs for a typical,hierarchical organization?

Accepted Answer

A) 
  
B) 
  
C) 
  
D) All of the above. 
A) 
  
B) 
  
C) 
  
D) All of the above.

Question 2

A type entity is used to depict the ________ relationship.

Accepted Answer

A) is-a-kind-of 
B) is-a-member-of 
C) is-a-piece-of 
D) is-a-group-of 
A) is-a-kind-of 
B) is-a-member-of 
C) is-a-piece-of 
D) is-a-group-of

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

Why is cost information stored in several relational tables?

Accepted Answer

Cost information is stored in several ta

Question 5

In an expenditure cycle diagram,which of the following is an example of an event that larger organizations might want to include in their extended REA model?

Accepted Answer

A) Request. 
B) Order. 
C) Ship Order. 
D) Fill Order. 
A) Request. 
B) Order. 
C) Ship Order. 
D) Fill Order.

Question 6

Type and group entities are similar in that both are abstractions that represent sets of

Accepted Answer

A) objects. 
B) semantics. 
C) attributes. 
D) tables. 
A) objects. 
B) semantics. 
C) attributes. 
D) tables.

Question 7

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 8

Using an REA database design,which of the below is false with regards to cost data?

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 9

Which of the following diagrams represents the cardinality pairs in a situation where customer orders are individually filled,but not all the items on a customer order are always available?

Accepted Answer

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

Question 10

If the actual cost of an inventory item is maintained as an attribute in the Inventory table,which inventory valuation method would an organization have to use?

Accepted Answer

A) LIFO. 
B) FIFO. 
C) Weighted Average. 
D) Specific Identification. 
A) LIFO. 
B) FIFO. 
C) Weighted Average. 
D) Specific Identification.

Question 11

Many companies sell software,music,or digital photographs over the Internet.They provide each customer with a digital copy of those resources,but not the actual resource itself.How will this company's REA model differ from those selling tangible inventory?

Accepted Answer

A) These companies do not need an Inventory table. 
B) The structure of Inventory table is completely different from that of mass-produced merchandise. 
C) The Inventory table is only different in that it doesn't need attributes such as quantity-on-hand, quantity-available, reorder point, and standard reorder quantity. 
D) The Inventory table need not include information about the standard list price of each item and its description. 
A) These companies do not need an Inventory table. 
B) The structure of Inventory table is completely different from that of mass-produced merchandise. 
C) The Inventory table is only different in that it doesn't need attributes such as quantity-on-hand, quantity-available, reorder point, and standard reorder quantity. 
D) The Inventory table need not include information about the standard list price of each item and its description.

Question 12

Why might an REA diagram show relationships between agents?

Accepted Answer

Relationships between internal agents ma

Question 13

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 14

Which of the following diagrams represents a situation where deliveries are frequently made to the specific warehouse where the delivered goods will be stored?

Accepted Answer

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

Question 15

The cardinality pair from the Financial Institution entity to the Cash resource has a ________ minimum and an ________ maximum because companies will probably only keep information about financial institutions with which they have accounts but may have more than one account at the same financial institution.

Accepted Answer

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

Question 16

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 17

The ________ entity is used to collect and summarize data about the raw materials,labor,and machine operations used during production of inventory.

Accepted Answer

A) Finished Goods Inventory 
B) Raw Materials 
C) Issue Raw Materials 
D) Work-in-Process 
A) Finished Goods Inventory 
B) Raw Materials 
C) Issue Raw Materials 
D) Work-in-Process

Question 18

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 19

Identify the inventory valuation method below that cannot be calculated in a database created using an REA modeling approach.

Accepted Answer

A) LIFO. 
B) FIFO. 
C) Weighted Average. 
D) none of the above 
A) LIFO. 
B) FIFO. 
C) Weighted Average. 
D) none of the above

Question 20

When modeling the issuance of debt,the maximum cardinality from Disburse Cash to Issue Debt is 1 because

Accepted Answer

A) interest is usually only paid at the maturity date. 
B) one check is written for the total interest due. 
C) The Issue Debt event is not related to Disburse Cash event; cash is received, not given. 
D) The minimum cardinality would be 1, but the maximum cardinality should be N. 
A) interest is usually only paid at the maturity date. 
B) one check is written for the total interest due. 
C) The Issue Debt event is not related to Disburse Cash event; cash is received, not given. 
D) The minimum cardinality would be 1, but the maximum cardinality should be N.

Exam 19: Special Topics in Rea Modeling

Which of the following diagrams represents the cardinality pairs for a typical,hierarchical organization?

A type entity is used to depict the ________ relationship.

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

Why is cost information stored in several relational tables?

In an expenditure cycle diagram,which of the following is an example of an event that larger organizations might want to include in their extended REA model?

Type and group entities are similar in that both are abstractions that represent sets of

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 of the below is false with regards to cost data?

Which of the following diagrams represents the cardinality pairs in a situation where customer orders are individually filled,but not all the items on a customer order are always available?

If the actual cost of an inventory item is maintained as an attribute in the Inventory table,which inventory valuation method would an organization have to use?

Many companies sell software,music,or digital photographs over the Internet.They provide each customer with a digital copy of those resources,but not the actual resource itself.How will this company's REA model differ from those selling tangible inventory?

Why might an REA diagram show relationships between agents?

Supplier number is least likely to be a foreign key in

Which of the following diagrams represents a situation where deliveries are frequently made to the specific warehouse where the delivered goods will be stored?

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

The ________ entity is used to collect and summarize data about the raw materials,labor,and machine operations used during production of inventory.

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

Identify the inventory valuation method below that cannot be calculated in a database created using an REA modeling approach.

When modeling the issuance of debt,the maximum cardinality from Disburse Cash to Issue Debt is 1 because

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

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