Identify primary and foreign keys. Using Microsoft Access, define the tables and set up the relationships corresponding

Fantastic news! We've Found the answer you've been seeking!

Question:

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.