Question 1

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

Question 2

In a database created using an REA model,the Bill of Materials entity is most analogous to

Accepted Answer

A)  the "bill" that can be sent to the customer who order the finished good(s). 
B)  the "recipe" needed to produce the finished good(s). 
C)  the "receipt" for the purchase of specific raw materials. 
D)  the "audit trail" that can be used to verify a finished good(s) was actually produced.

Question 3

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)

Question 4

While not required,connecting the Time Used entity to specific business events enables

Accepted Answer

A)  evaluating performance at a very detailed level. 
B)  general performance evaluation. 
C)  evaluating the quality of the services received. 
D)  determining productivity of employees, such as how many customer calls were made, or how many sales were made.

Question 5

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

Accepted Answer

A) 
 
B) 
 
C) 
 
D)

Question 6

Which of the following diagrams represents a situation where one or more warehouses may be empty,and production of new products has been delayed due to difficulty obtaining materials?

Accepted Answer

A) 
 
B) 
 
C) 
 
D)

Question 7

Assume an organization sells digital photographs to customers through its website (the company only sells photographs in digital format,it does not provide a physical copy of any photograph).Identify the attribute below that the organization would not need in its Inventory entity.

Accepted Answer

A)  reorder point 
B)  price 
C)  photograph description 
D)  primary key

Question 8

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

Accepted Answer

A)  objects. 
B)  semantics. 
C)  attributes. 
D)  all of the above

Question 9

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

Question 10

Identify the entity linked to almost every other entity in an REA diagram for HRM/payroll cycles.

Accepted Answer

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

Question 11

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.

Question 12

The relationship between the Rent Item and Return Item events is most likely 1:1 for all except which of the following reasons?

Accepted Answer

A)  A return must be for a rented item. 
B)  A rented item can only be returned once. 
C)  Rented items are accounted for separately. 
D)  All rented items must be returned.

Question 13

Customer number is least likely to be a foreign key in which entity of an an expanded revenue cycle REA diagram?

Accepted Answer

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

Question 14

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.

Question 15

The relationship between the Acquire Services and Disburse Cash events is modeled as ________ to reflect the common situation in which the organization obtains the use of a specific service for a particular period of time and makes a payment each month for the services it acquired and used that month.

Accepted Answer

A)  1:1 
B)  1:N 
C)  M:N 
D)  none of the above

Question 16

Which of the following represents the cardinality pairs in a situation where a finished product requires one or more machine operations,and machines usage is tracked by specific production run(s)?

Accepted Answer

A) 
 
B) 
 
C) 
 
D)

Question 17

In an REA diagram for the HR/Payroll cycle,the relationship between Employees and Training is typically 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.

Question 18

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)

Question 19

A groups entity is used to depict the following relationship.

Accepted Answer

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

Question 20

Supplier number is most likely to be a foreign key in

Accepted Answer

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

Exam 19: Special Topics in Rea Modeling

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.

In a database created using an REA model,the Bill of Materials entity is most analogous to

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

While not required,connecting the Time Used entity to specific business events enables

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

Which of the following diagrams represents a situation where one or more warehouses may be empty,and production of new products has been delayed due to difficulty obtaining materials?

Assume an organization sells digital photographs to customers through its website (the company only sells photographs in digital format,it does not provide a physical copy of any photograph) .Identify the attribute below that the organization would not need in its Inventory entity.

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

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.

Identify the entity linked to almost every other entity in an REA diagram for HRM/payroll cycles.

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

The relationship between the Rent Item and Return Item events is most likely 1:1 for all except which of the following reasons?

Customer number is least likely to be a foreign key in which entity of an an expanded revenue cycle REA diagram?

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?

Which of the following represents the cardinality pairs in a situation where a finished product requires one or more machine operations,and machines usage is tracked by specific production run(s) ?

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

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?

A groups entity is used to depict the following relationship.

Supplier number is most likely to be a foreign key in