Question $1(1$ point$)$

Given the following case, you are to answer the following questions.

Bob's Supply needs to keep track of the parts they have in their inventory. He wants to know the description of each part, the color of each part, how many of each item is currently in stock QOH, and how much each part costs him. BS also needs to keep track of who supplies each part, the supplier's name, contact person, and telephone number. We know that each part in inventory has only one supplier, but some suppliers supply multiple parts to BS$.$ Bob wants each part and each supplier to be assigned a unique identifying number.

Question $1$

Identify the tables for the design of Bob's Supply database.

Supplier

Part

Both A and $B$

Bob's Supply

Question $2(1$ poir

Question $2(1)$ poine$)$

In Bob's Supply Store database, the "part description" is a field in which tabien.

Question $5(1$ point$)$

In Bob's Supoly Store database, the home address is a field in which table.

Supplier

Part

Employee

None of the above