Question 1

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

Question 2

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 3

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) 1:M

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.

Question 5

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 6

Data about actual raw materials used in production is most appropriately stored which of the entities below?

Accepted Answer

A) Finished Goods. 
B) Raw Materials. 
C) Raw Materials Issuance. 
D) Work-in-Process.

Question 7

In an REA database model,the Bill of Materials entity contains information about what?

Accepted Answer

A) The raw materials used to make a finished product. 
B) The actual cost of the raw materials used to make a finished product. 
C) The vendor from whom the raw materials was purchased 
D) All of the above.

Question 8

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.

Question 9

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

Accepted Answer

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

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.

Question 11

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

Accepted Answer

The answer of Why is the event Issue Debt often...

Question 12

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 13

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 14

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

Accepted Answer

A) 
 
B) 
 
C) 
 
D)

Question 15

Why might an REA diagram show relationships between agents?

Accepted Answer

The answer of Why might an REA diagram show relationships...

Question 16

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) Type and Group.

Question 17

A groups 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

Question 18

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

Accepted Answer

The answer of Describe the relationships between Recruiting event and...

Exam 19: Special Topics in Rea Modeling

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 .