Medium question 2
Read the following paragraph on database construction and answer questions Q93
through Q96.
Company A manufactures bread at 10 plants. In recent years, the kinds of bread handled
have increased. In order to streamline purchasing of the ingredients and make information on past purchases more readily searchable, the company plans to computerize work
that was previously performed manually. Accordingly, the purchasing department is
tasked with designing the database structure. The conditions for the product (bread) and
the ingredients are as follows:
(1) The type of the product determines where it will be manufactured.
(2) Each product uses at least one (1) ingredient.
(3) Each ingredient is used in at least one (1) product.
The database structure designed by the purchasing department is as follows:
Product table
Product ID
Manufacturing
date
Planned manufacturing volume
Plant ID
Ingredient table
Ingredient ID
Ingredient name
Ingredient usage table
Product ID
Q93.
Technology
Ingredient ID
Amount used
Which of the following is the appropriate combination of (A) and (B) for the primary and
foreign keys of the ingredient usage table?
A
B
a)
b)
Many-to-many
Product ID and ingredient ID
One-to-one
Ingredient ID
c)
d)
One-to-many
Product ID
Many-to-one
Product ID and ingredient ID
Practice exam 3
A
In the ingredient usage table,
describes the relation between product and
B
ingredient, and
is the primary key. Based on the foreign key concept,
product IDs that do not exist in the product table and ingredient IDs that do not exist in
the ingredient table cannot be registered in the ingredient usage table.
396