Given the following case, you are to answer the two questions on the following pages. When completed download this document into the drop box labeled BISI SLO#1   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 be assigned a unique identifying number. Table 1: Parts

Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 3MC
icon
Related questions
Question

Given the following case, you are to answer the two questions on the following pages. When completed download this document into the drop box labeled BISI SLO#1

 

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 be assigned a unique identifying number.

Table 1: Parts

 

 

Attribute
Part_ID
Description
Color
QOH
Cost
Supplier_ID
Function
Unique
identifier for
each part
Description of
the part
Color of the
part
Quantity on
hand (stock)
Cost of each
part
Unique
identifier for
the supplier of
the part
Transcribed Image Text:Attribute Part_ID Description Color QOH Cost Supplier_ID Function Unique identifier for each part Description of the part Color of the part Quantity on hand (stock) Cost of each part Unique identifier for the supplier of the part
Table 2: Suppliers
Attribute
Supplier_ID
Supplier_Name
Contact Person
Telephone Number
Function
Unique
identifier for
each supplier
Name of the
supplier
Contact
person for
the supplier
Telephone
number for
the supplier
Transcribed Image Text:Table 2: Suppliers Attribute Supplier_ID Supplier_Name Contact Person Telephone Number Function Unique identifier for each supplier Name of the supplier Contact person for the supplier Telephone number for the supplier
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Probability Problems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning