1. Refer to the association marked with the number 2 in the preceding diagram. Which of the following is the best way to implement the association in a relational database?

Multiple Choice

• Post the primary key of bill of materials as a foreign key in raw materials.

• Post the primary key of raw materials as a foreign key in bill of materials.

• Create a linking table between raw materials and bill of materials.

• The location of the foreign key is optional.

• None of these is the best way to implement the relationship.

2. Refer to the association marked with the number 3 in the preceding diagram. Which of the following is the best description of purpose the association?

Multiple Choice

• Links actual material costs to each finished goods item produced.

• Links actual labor costs to each finished goods item produced.

• Specifies planned material costs for each finished goods item.

• Specifies planned labor costs for each finished goods item.

• None of these is a description of the purpose of the association.

3. Refer to the association marked with the number 3 in the preceding diagram. Which of the following is the best description of the association?

Multiple Choice

• Each bill of materials is related to a minimum of zero finished goods.

• Each bill of materials is related to a minimum of one finished good.

• Each bill of materials is related to a maximum of many finished goods.

• Each bill of materials is not necessarily related to a finished good.

• None of these is a description of the association.

4. Refer to the association marked with the number 3 in the preceding diagram. Which of the following is the best way to implement the association in a relational database?

Multiple Choice

• Post the primary key of bill of materials as a foreign key in finished goods.

• Post the primary key of finished goods as a foreign key in bill of materials.

• Create a linking table between finished goods and bill of materials.

• The location of the foreign key is optional.

• None of these is the best way to implement the relationship.

5. Refer to the association marked with the number 4 in the preceding diagram. Which of the following is the best description of the purpose of the association?

Multiple Choice

• Shows that the conversion and sales process are integrated via finished goods.

• Shows that the conversion process is triggered by an order for a finished good.

• Links finished goods produced by the conversion process to orders (by customers).

• Links finished goods to subsequent cash receipts in the sales process.

• None of these is a description of the purpose of the association.

6. Refer to the association marked with the number 4 in the preceding diagram. Which of the following is the best description of the association?

rev: 10_27_2017_QC_CS-107092

Multiple Choice

• Each finished good is related to one order.

• Each finished good is related to zero to many orders.

• Each finished good is related to a minimum of one order.

• Each finished good is related to a maximum of one order.

• None of these is a description of the association.

7. Refer to the association marked with the number 5 in the preceding diagram. Which of the following is the best way to implement the association in a relational database?

Multiple Choice

• Post the primary key of Sunset partners as a foreign key in labor operations.

• Post the primary key of labor operations as a foreign key in Sunset partners.

• Create a linking table between Sunset partners and labor operations.

• The location of the foreign key is optional.

• None of these is the best way to implement the relationship.

8. Refer to the association marked with the number 5 in the preceding diagram. Which of the following is the best description of the association?

Multiple Choice

• Each labor operation is related to only one Sunset partner.

• Each labor operation is related to many Sunset partners.

• Labor operations are related to a minimum of zero Sunset partners.

• Labor operations are related to a maximum of one Sunset partner.

• None of these is a description of the association.

9. Refer to the association marked with the number 6 in the preceding diagram. Which of the following is the best description of purpose of the association?

Multiple Choice

• Authorizes the issue of raw materials.

• Controls the transfer of raw materials to work-in-process.

• Relates specific raw material issues to the controlling authorization.

• All of these describe the purpose of the association.

• None of these describes the purpose of the association.

10. Refer to the association marked with the number 6 in the preceding diagram. Which of the following is the best description of the association?

Multiple Choice

• Each production authorization is related to a minimum of zero material issues.

• Each production authorization is related to a minimum of one material issue.

• Each production authorization is related to a maximum of one material issue.

• Each production authorization is related to a maximum of zero material issues.

• None of these is a description of the association.

Required information Refer to the following integrated diagram, showing part of the purchases and sales processes linked to the conversion process, for Questions 11 through 25. Purchases Supplier Material Issue 6 Production O Sunset Partners Material 0. Authorization 1.1 1.1 1.1 Labor Operations 0 Order Customer 0