Given the following case you are to answer the two questions on the following pages. Bob’s 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 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 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.
Given the following case you are to answer the two questions on the following pages.
Bob’s 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 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 have assigned an identifying number.
1. Identify the tables needed to design the
2. Create the database design for this case below using an Entity-Relationship Diagram.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
