Question 1

The linking table between Supplier Categories and Product Categories would likely contain the attribute summarizing year-to-date purchases for each supplier category and product category combination.

Accepted Answer

True

Question 2

The Cash Disbursements table would have three foreign keys.

Accepted Answer

Cash Disbursements table would typically have foreign keys referencing the vendor, bank account, and the transaction it is related to.

Question 3

The linking table between Purchase Orders and Products would likely indicate the quantity of each product ordered and the quantity of each product received.

Accepted Answer

The linking table between Purchase Orders and Products typically includes the quantity of each product ordered and the quantity of each product received, among other details such as the purchase order ID, product ID, unit price, and total cost. This information is important for tracking inventory levels and managing the purchasing process.

Question 4

In a BPMN collaboration model of the purchase process, which of the following is the appropriate term for the message flows between pools?
A. Orchestration
B. Choreography
C. Collaboration
D. Intermediate events

Accepted Answer

Choreography in BPMN specifically refers to the way business processes interact with each other through message flows, especially when detailing the interactions between different participants (pools) in a collaboration model. It focuses on the sequence and conditions of interactions.

Question 5

In a BPMN collaboration model of the purchase process, one pool describes the focal organization's activities and the other pool describes what?
A. The supplier's activities
B. The customer's activities
C. The sequence of steps in the process
D. The message flows between the pools

Accepted Answer

In a BPMN collaboration model of the purchase process, one pool describes the focal organization's activities, and the other pool describes the supplier's activities. Therefore, the best choice is A. Choice B is not correct as the customer's activities are already included in the focal organization's pool. Choice C is not correct as the sequence of steps in the process can be represented within each pool as well as between the pools. Choice D is not correct as the message flows between the pools can be represented using message flow objects.

Question 6

Which of the following least reflects the purpose of a business rule in the purchase process?
A. Ensure suppliers are paid on time
B. Require segregation of order, receiving, and payment duties
C. Ensure suppliers are satisfied
D. Ensure an audit trail

Accepted Answer

While ensuring supplier satisfaction is an important aspect of building and maintaining good relationships with suppliers, it is not a primary purpose of a business rule in the purchase process. The primary purposes listed in the other answer choices are to ensure that suppliers are paid on time, to require segregation of duties to prevent fraud and errors, and to ensure an audit trail for accountability and transparency purposes.

Question 7

The associate between Purchase Orders and Purchases would be implemented with a linking table.

Accepted Answer

The answer of The associate between Purchase Orders and Purchases...

Question 8

The Purchase Orders table would contain two foreign keys to implement the associations with Employees.

Accepted Answer

A Purchase Order would have an Employee who requested it (requester), and an Employee who authorized it (approver). Therefore, the Purchase Orders table would need two foreign keys to link to the Employees table.

Question 9

The association between Purchase Orders and Products would be implemented with a linking table.

Accepted Answer

A linking table, also known as a junction table or bridge table, is used to associate two tables in a many-to-many relationship. In this case, the Purchase Order and Product tables likely have a many-to-many relationship, as a single purchase order can contain multiple products, and a single product can appear on multiple purchase orders. Therefore, a linking table would be used to connect the two tables and create a proper relationship.

Question 10

The Products table would include a foreign key to link it to Product Categories.

Accepted Answer

This is true as each product belongs to a certain product category, and the foreign key in the Products table would establish this relationship.

Question 11

The Purchase Orders table would have the same foreign keys as the Purchases table.

Accepted Answer

The Purchase Orders table and the Purchases table may have different foreign keys depending on the database design and the relationships between entities.

Question 12

The Purchases table would have four foreign keys.

Accepted Answer

The Purchases table usually has foreign keys for the Customer, Product, Store, and Employee tables.

Question 13

In a BPMN collaboration model of the purchase process, which of the following best describes the purpose of swimlanes?
A. Capturing the process complexity
B. Clarifying the interaction between pools
C. Showing the sequence of activities in a pool
D. Showing different jobs in the purchase process

Accepted Answer

Swimlanes in a BPMN collaboration model are used to represent different roles or parties involved in the process. In the purchase process, swimlanes could represent the different departments or individuals involved in the process, such as the purchasing department, the finance department, and the supplier. Therefore, the purpose of swimlanes is to show different jobs or roles in the purchase process.

Question 14

Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Purchases and Cash Disbursements classes?
  
A. Each supplier must be paid for the purchases from that supplier
B. Disbursements are made after the purchases are recorded
C. One purchase can result in multiple payments to the supplier
D. Each check written to the supplier is for one specific purchase

Accepted Answer

The answer of Review the following diagram. Which answer provides...

Question 15

The Cash Disbursements table would have three foreign keys.

Accepted Answer

The Cash Disbursements table would have foreign keys for the Vendor table, the Account table, and the Employee table.

Question 16

The association between Purchase Orders and Cash Disbursements would be implemented with a linking table.

Accepted Answer

The answer of The association between Purchase Orders and Cash...

Question 17

The association between Purchase Orders and Cash Disbursements could be implemented with a foreign key in either table but not both.

Accepted Answer

This is because a Purchase Order would have a one-to-many relationship with Cash Disbursements (each Purchase Order may have multiple Cash Disbursements associated with it), therefore the Purchase Order table would have a foreign key referencing the primary key of the Cash Disbursements table. However, putting a foreign key in the Cash Disbursements table referencing the Purchase Orders table would not make sense as one Cash Disbursement could be associated with multiple Purchase Orders.

Question 18

A query using Purchase Orders and Cash Disbursements could report accounts payable by showing records where the foreign key was NULL (blank).

Accepted Answer

A query showing accounts payable could use a NULL foreign key to indicate that a purchase order has not yet been matched with a cash disbursement, meaning the payment is still outstanding.

Question 19

Each Purchase Order would be ultimately linked to one cash disbursement.

Accepted Answer

Not every purchase order results in a single cash disbursement; multiple orders can be paid together, or a single order can be paid in installments.

Question 20

The Purchase Orders table would have five foreign keys.

Accepted Answer

The number of foreign keys in a Purchase Orders table depends on the specific database schema and relationships with other tables, not a fixed number.

Quiz 6: Purchases and Payments Business Process

The linking table between Supplier Categories and Product Categories would likely contain the attribute summarizing year-to-date purchases for each supplier category and product category combination.

The Cash Disbursements table would have three foreign keys.

The linking table between Purchase Orders and Products would likely indicate the quantity of each product ordered and the quantity of each product received.

In a BPMN collaboration model of the purchase process, which of the following is the appropriate term for the message flows between pools? A. Orchestration B. Choreography C. Collaboration D. Intermediate events

In a BPMN collaboration model of the purchase process, one pool describes the focal organization's activities and the other pool describes what? A. The supplier's activities B. The customer's activities C. The sequence of steps in the process D. The message flows between the pools

Which of the following least reflects the purpose of a business rule in the purchase process? A. Ensure suppliers are paid on time B. Require segregation of order, receiving, and payment duties C. Ensure suppliers are satisfied D. Ensure an audit trail

The associate between Purchase Orders and Purchases would be implemented with a linking table.

The Purchase Orders table would contain two foreign keys to implement the associations with Employees.

The association between Purchase Orders and Products would be implemented with a linking table.

The Products table would include a foreign key to link it to Product Categories.

The Purchase Orders table would have the same foreign keys as the Purchases table.

The Purchases table would have four foreign keys.

In a BPMN collaboration model of the purchase process, which of the following best describes the purpose of swimlanes? A. Capturing the process complexity B. Clarifying the interaction between pools C. Showing the sequence of activities in a pool D. Showing different jobs in the purchase process

The Cash Disbursements table would have three foreign keys.

The association between Purchase Orders and Cash Disbursements would be implemented with a linking table.

The association between Purchase Orders and Cash Disbursements could be implemented with a foreign key in either table but not both.

A query using Purchase Orders and Cash Disbursements could report accounts payable by showing records where the foreign key was NULL (blank).

Each Purchase Order would be ultimately linked to one cash disbursement.

The Purchase Orders table would have five foreign keys.