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

7

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

Multiple Choice

• Each supplier participates in a minimum of zero purchases.

• Each supplier participates in at least one purchase.

• Each supplier participates in a maximum of one purchase.

• Supplier in the internal agent in the purchase process.

• None of these is a description of the association.

8.

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

Multiple Choice

• The association links finished goods to the corresponding bill of material.

• The association links purchases to raw materials.

• The association identifies the raw materials in a bill of materials.

• All of these descriptions are purposes of the association.

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

9.

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

Multiple Choice

• Each bill of material entry specifies one raw material.

• Each bill of material entry specifies multiple raw materials.

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

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

• None of these is a description of the association.

10.

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.

Purchases Supplier Materials Material Issue 1..1 Bill of Material Production Authorization Sunset Partners Products Labor Operations Order Customer lo