Consider the following six relations for an order-processing database applicatio

Question

Consider the following six relations for an order-processing database application in a company, please specify the foreign keys for this schema. CUSTOMER (Cust#, Cname, City) ORDER (Order#, Odate, Cust#, Ord_ amount) ORDER_ITEM (order#, Item#, Qty) ITEM (Item#, Unit_ price) SHIPMENT (Order#, Warehouse#, Shipdate) WAREHOUSE (warehouse#, city) Here, Ord_ amount refers to total amount of an order; Odate is the date the order was placed; and Ship_ data is the data an order (or part of an order) is shipped from the warehouse. Assume that an order can be shipped from several warehouse..

Explanation / Answer

In the give schema following tables have the foreign keys:

1. SHIPMENT- Order and Warehouse are foreign keys

2. ORDER ITEM- Order and Item are foreign keys

3. ORDER- Cust is the foreign key

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---