Question 1

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

The answer of Which of the following diagrams represents a...

Question 2

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

The answer of Which of the following diagrams represents the...

Question 3

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

The answer of Which of the following diagrams represents the...

Question 4

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

Accepted Answer

The temporal difference is indicated by the minimum cardinality of 0 for Order Inventory, suggesting that an order may not immediately follow a request.

Question 5

Why is cost information stored in several relational tables?

Accepted Answer

The answer of Why is cost information stored in several...

Question 6

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

Accepted Answer

The answer of An organization that sells digital products,such as...

Question 7

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

The cardinality pair from the Financial Institution entity to the Cash resource should have a minimum of 1 as there must be at least one financial institution associated with the company's cash resources. However, there could be multiple accounts at the same financial institution, so the maximum should be N (many). Therefore, the best choice is C, which has a minimum of 1 and a maximum of N.

Question 8

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

The answer of If the actual cost of an inventory...

Question 9

Financial Institution number is most likely to be a foreign key in

Accepted Answer

Financial Institution number is most likely to be a foreign key in Cash because it references the primary key in the Financial Institution table.

Question 10

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

Reorder point is not needed for a digital photograph as there is no physical inventory that needs to be restocked. The other attributes (price, photograph description, and primary key) are necessary for managing and selling digital photographs on the organization's website.

Question 11

Supplier number is most likely to be a foreign key in

Accepted Answer

The Supplier number would most likely be a foreign key in the "Receive Inventory" table, as this table would need to reference the Supplier table to identify from which supplier the inventory was received. This establishes a relationship between the two tables, where the Supplier table contains the primary key (Supplier number), and the Receive Inventory table uses this as a foreign key to reference the supplier details.

Question 12

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

Accepted Answer

The answer of In which entity would an item's actual...

Question 13

Which of the following diagrams represents a situation where items rented by a customer must be returned intact,and several rented items could be returned at the same time?

Accepted Answer

The answer of Which of the following diagrams represents a...

Question 14

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

Accepted Answer

All of the above business activities can be modeled using an REA diagram. REA (resources, events, and agents) diagrams are a standardized method for modeling and documenting business processes. Purchase requisitions can be modeled as a resource, rental transactions can be modeled as events, and intangible assets can be modeled as resources. Therefore, all of the options can be modeled using REA diagrams.

Question 15

Which of the following diagrams represents a situation where a firm offers some services that have not ever been sold,offers other services that have been performed many times,and provides services sometimes performed together to clients?

Accepted Answer

The answer of Which of the following diagrams represents a...

Question 16

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

The answer of Which of the following diagrams represents a...

Question 17

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

Accepted Answer

A standard cost is an average of costs that can be allocated to products, and it is generally associated with inventory. Therefore, item standard cost information would most likely be maintained in the Inventory entity.

Question 18

Which of the following diagrams represents a situation where a business that rents lawn mowers (not all of which get rented)writes separate rental agreements for each mower,so renters don't have to return all the rented items at the same time?

Accepted Answer

The answer of Which of the following diagrams represents a...

Question 19

One of the benefits of an integrated enterprise-wide data model is that

Accepted Answer

The answer of One of the benefits of an integrated...

Question 20

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

Accepted Answer

The REA (Resources, Events, Agents) modeling approach is a database design methodology used for capturing information about resources, events, and agents involved in business transactions. It does not inherently limit the ability to calculate inventory valuation methods such as LIFO (Last In, First Out), FIFO (First In, First Out), or Weighted Average. These inventory valuation methods can be implemented in a database designed using the REA model by appropriately structuring the data and applying the necessary calculations.

Quiz 19: Special Topics in Rea Modeling

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?

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 customer orders are individually filled,but not all the items on a customer order are always available?

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

Why is cost information stored in several relational tables?

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

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.

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?

Financial Institution number is most likely to be a foreign key in

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.

Supplier number is most likely to be a foreign key in

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

Which of the following diagrams represents a situation where items rented by a customer must be returned intact,and several rented items could be returned at the same time?

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

Which of the following diagrams represents a situation where a firm offers some services that have not ever been sold,offers other services that have been performed many times,and provides services sometimes performed together to clients?

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

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

Which of the following diagrams represents a situation where a business that rents lawn mowers (not all of which get rented) writes separate rental agreements for each mower,so renters don't have to return all the rented items at the same time?

One of the benefits of an integrated enterprise-wide data model is that

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