Question 1

Supplier number is least likely to be a foreign key in

Accepted Answer

Warehouse is a system used for storing goods, materials, and finished products. It is unlikely to have a foreign key referencing a supplier number as it is not directly related to the supply chain process. The other options involve the supply chain process and would have a higher likelihood of having a foreign key referencing a supplier number.

Question 2

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 3

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

Why is cost information stored in several relational tables?

Accepted Answer

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

Question 6

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 describes the relationship between the Financial Institution entity and the Cash resource. The minimum cardinality is 1 because a financial institution must necessarily have at least one account associated with it in order for information to be stored about it. The maximum cardinality is N because a company may have multiple accounts with the same financial institution. Therefore, the best choice is C, with a minimum cardinality of 1 and a maximum cardinality of N.

Question 7

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

The answer of Relationships between resources and agents,such as Inventory...

Question 8

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 a situation where items are rented and returned intact, and multiple rented items can be returned at the same time. The arrows indicate the flow of items back to the rental system, and the dotted lines indicate that the items are returned as a group rather than individually. The other diagrams do not show the same level of complexity in the rental and return process.

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

Since the same inventory items may be stored in several different warehouses,the maximum cardinality from Inventory to Warehouse is most likely

Accepted Answer

Since the same inventory items can be stored in multiple warehouses, the relationship between Inventory and Warehouse has a one-to-many cardinality. This means that the maximum cardinality from Inventory to Warehouse is N (many).

Question 11

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 12

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

Accepted Answer

An REA diagram cannot model intangible assets because they do not have a physical existence.

Question 13

Why might an REA diagram show relationships between resources and agents?

Accepted Answer

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

Question 14

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 15

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

In diagram B, there are frequent arrows going from the supplier directly to the specific warehouse, indicating that deliveries are made directly to the warehouse where the goods will be stored. The other diagrams show goods being delivered to a central location or a general warehouse before being distributed to specific locations.

Question 16

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 Inventory can exist without an Order Inventory, but an Order Inventory cannot exist without a corresponding Request Inventory. Therefore, the minimum cardinality for Order Inventory should be 0, which is reflected in choice D.

Question 17

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 18

Give an example of an M:N Agent-Event relationship.

Accepted Answer

The answer of Give an example of an M:N Agent-Event...

Question 19

Warehouse number is most likely to be a foreign key in

Accepted Answer

The warehouse number is most likely to be a foreign key in the "Receive Inventory" table as it is the table that tracks the incoming inventory to the warehouse. The other options, "Order Inventory" and "Inventory," are tables that track the items to be ordered or sold and would not necessarily require the use of the warehouse number as a foreign key. "Disburse Cash" is a completely unrelated function and would not involve any inventory management.

Question 20

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.

Quiz 19: Special Topics in Rea Modeling

Supplier number is least likely to be a foreign key in

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?

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?

Why is cost information stored in several relational tables?

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.

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 .

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?

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

Since the same inventory items may be stored in several different warehouses,the maximum cardinality from Inventory to Warehouse is most likely

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?

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

Why might an REA diagram show relationships between resources and agents?

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

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

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

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?

Give an example of an M:N Agent-Event relationship.

Warehouse number is most likely to be a foreign key in

Supplier number is most likely to be a foreign key in