Given the following case you are to answer the two questions on the following pages.

Bobs Supply (BS) 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 in stock [QOH], and how much each part costs him. BS also needs to keep track of who supplies each part, the suppliers 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 have assigned an identifying number.

1. Identify the tables needed to design the database and the fields [attributes] needed for each table and the role or function that some attrIbutes take on.

2. Create the database design for this case below using an Entity-Relationship Diagram.