Question

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 Materials Material Issue 1..1 Bill of Material Production Authorization Sunset Partners Products Labor Operations Order Customer lo.."

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.

Answer 1

7	Each supplier participates in a minimum of zero purchases.
	Explanation: Considering the association between employee and sale at number 1 indicate
	each employee can participate in minimum of zero and maximum of many sales.