Answered: Given the following case, you are to…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

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

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

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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