Required Write out a set of relational tables that correspond to the class diagram that you prepared for problem 2 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 Paiges yogurt shop 2 3 4 5 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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 17, 2024

Required: Write out a set of relational tables that correspond to the class diagram that you prepared for problem 2. Identify primary and foreign keys.

Required:

Write out a set of relational tables that correspond to the class diagram that you prepared for problem 2. 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 Paiges 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.