Refer to the following integrated diagram, showing part of the purchases and sales processes linked to the conversion process, for Questions 11 through 25.

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.

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.

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.

0. 0." 1.1 Purchases Supplier 0.* 0." Material Materials 1.. Issue 1.1 1. 1.1 1.1 1.1 Bill of 0." Production Sunset Material 1.1 0. Authorization Partners 1. 1.1 1.1 1.1 0. 1.1 Labor Products Operations 1. 0. 1.1 0." Order Customer 0. 0. 0." 1.1 Purchases Supplier 0.* 0." Material Materials 1.. Issue 1.1 1. 1.1 1.1 1.1 Bill of 0." Production Sunset Material 1.1 0. Authorization Partners 1. 1.1 1.1 1.1 0. 1.1 Labor Products Operations 1. 0. 1.1 0." Order Customer 0