Question 1

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 2

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.

Question 3

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 4

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 5

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 6

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 relevant for a digital photograph inventory as there is no physical stock to reorder. Price and photograph description are both necessary attributes to sell and manage inventory of digital photographs. Primary key is required to uniquely identify each photograph in the inventory.

Question 7

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 8

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 diagram in option B shows deliveries being made directly to a specific warehouse, which is labeled as "Warehouse A". This suggests that the delivered goods will be stored in that warehouse. The other diagrams do not clearly show this scenario.

Question 9

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

Accepted Answer

The answer of Financial Institution number is most likely to...

Question 10

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 11

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 12

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 diagram in option B shows that each customer order can be filled with one or more items, but not all items on a customer order may be available. This aligns with the given situation. Option A represents a one-to-one relationship between customer orders and items, which does not match the situation. Option C represents a situation where all items on a customer order must be available, which is not the case here. Option D represents a many-to-many relationship, which is not accurate for the given scenario.

Question 13

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 14

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

Accepted Answer

Standard cost information for an item is typically maintained in the inventory entity. This allows for easy tracking of inventory costs and provides the necessary information for financial reporting and cost analysis. The order_inventory entity may contain information related to purchasing and ordering processes, but it wouldn't necessarily include standard cost data for an item. The inventory-order_inventory entity doesn't exist; it seems to be a combination of the two previously mentioned entities. A cost entity could potentially be used to store cost data, but it wouldn't be the most appropriate place for standard cost information specifically related to inventory.

Question 15

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 16

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 17

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 18

Why is cost information stored in several relational tables?

Accepted Answer

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

Question 19

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

Accepted Answer

The temporal difference between Request Inventory and Order Inventory is that a request may or may not result in an order. Therefore, the minimum cardinality for Order Inventory should be 0 to allow for the possibility of no orders being placed. The other options do not directly address the temporal difference between the two entities.

Question 20

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

Diagram B shows multiple items being returned at the same time and includes a check to ensure that they are returned intact. A and D show only one item being returned at a time, while C does not indicate any requirement for items to be returned intact.

Quiz 19: Special Topics in Rea Modeling

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.

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

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?

Supplier 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.

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

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

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

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

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

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?

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

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?

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?

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.

Why is cost information stored in several relational tables?

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

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?