Identify primary and foreign keys. Using Microsoft Access, define the tables and set up the relationships corresponding to your diagram. Then answer questions 1 to 6 below based on your tables.

1). How many relational tables are necessary to implement your model for Paige’s yogurt shop?

2). Which of the following is the best primary key for the INVENTORY table?

• Inventory description

• Inventory price

• Inventory number

• Inventory quantity

3). Which of the following is the best way to implement the association between INVENTORY and PURCHASES tables?

• Post the primary key of PURCHASES in INVENTORY as a foreign key.

• Post the primary key of INVENTORY in PURCHASES as a foreign key.

• Create a linking table between INVENTORY and PURCHASES with a primary key that combines the primary keys of INVENTORY and PURCHASES

• Create a new table that includes the primary keys of INVENTORY and PURCHASES as foreign keys

• None of these is the best option.

4). Which of the following is the best option for the SUPPLIERS table primary key?

• Supplier phone number

• Supplier number (assigned by yogurt shop)

• Supplier name

• Supplier contact person

• None of these is a good option

5). Which of the following is the best option for the PURCHASES table primary key?

• Purchase quantity

• Purchase date

• Purchase number (assigned by yogurt shop)

• Purchase description

• None of these is a good option

6). Which of the following is the best way to implement the association between SUPPLIERS and PURCHASES tables?

• Post the primary key of PURCHASES in SUPPLIERS as a foreign key.

• Post the primary key of SUPPLIERS in PURCHASES as a foreign key.

• Create a linking table between SUPPLIERS and PURCHASES with a primary key that combines the primary keys of SUPPLIERS and PURCHASES

• Create a new table that includes the primary keys of SUPPLIERS and PURCHASES as foreign keys

• None of these is the best option.