Create tables for the following question: Project Description The General Mercha

Question

Create tables for the following question:

Project Description The General Merchandise Inc. (GMI) has asked you to design and implement a purchase order system. The GMI sells many office products, such as Pencil, Pen, and the like. Each product has a product ID and description. GMI constantly orders products from its suppliers, such as Staples, Office Depot, etc. To simplify the matter, each time we place an order with a supplier, only one item is ordered. Not every supplier carries every product so we keep track authorized/available suppliers for each product. For instance, the authorized suppliers of Item p1 Pencil are s1 and s3; the authorized suppliers of Item p3 Magic Marker are s1 and s2. Notice that the same item may have different price with different suppliers. For instance, pl Pencil is $2.50 if we order it from Staples, and $2.00 if we order from Office Max. GMI maintains the price list in its database.

Explanation / Answer

In this we have 4 tables:

1. Product

2. Supplier

3. Product Supplier

4. Order

Below are the table schema:-

Product

where PID = Product Id,

PName = Product Name

and PDescription = Product Description

Supplier

where SID = Supplier Id

and SName = Supplier Name

Product Supplier

where SID = Supplier Id,

PID = Product Id,

and Price = Price

Order

where OID = Order Id,

PID = Product Id,

and SID = Supplier Id

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.