Computers and Technology, 22.08.2020 19:01 thefish81

Consider the following six relations for an order-processing database application in a company:
CUSTOMER (Cust#, Cname, City)
ORDER (Order#, Odate, Cust#, Ord_Amt)
ORDER_ITEM (Order#, Item#, Qty)
ITEM (Item#, Unit_price)
SHIPMENT (Order#, Warehouse#, Ship_date)
WAREHOUSE (Warehouse#, City)
Here, Ord_Amt refers to total dollar amount of an order; Odate is the date the order was placed; Ship_date is the date an order (or part of an order) is shipped from the warehouse. Assume that an order can be shipped from several warehouses. Specify the foreign keys for this schema, stating any assumptions you make. What other constraints can you think of for this database?

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 21.06.2019 13:30, zeesharpe05

Using the find and replace tool would be most appropriate when changing the company name when the same letter is sent to different companies. inserting a date field. suggesting alternate word choices with the same meaning. placing images alongside text.

Answers: 3

continue

Computers and Technology, 22.06.2019 17:30, yoyo9661

Under which key category do the page up and page down keys fall? page up and page down keys fall under the keys category.

Answers: 1

continue

Computers and Technology, 22.06.2019 23:30, bri2008

Which of the following is not a symptom of chronic fatigue syndrome

Answers: 2

continue

Computers and Technology, 23.06.2019 07:30, devnnn44

What is the original authority for copyright laws