Order - OrderItemStatus OrderItemStatusI D OrderItemID...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Order OrderID OrderDate OrderTotal CustomerID 1 1 Apr 2002 $100.00 1 OrderItem OrderItemID OrderID ItemID ItemQuantity ItemTotal 1 1 5 2 $60.00 2 1 7 1 $40.00 OrderItemStatus OrderItemStatusI D OrderItemID Status StatusDate StatusInfo There is no entry in OrderItemStatus because no action has been taken except the order was placed. That information is already in the Order table. Let’s assume that the Widgets (Item ID 5) were placed on backorder and the Thingamajig (Item ID is 7) was shipped on 2 Apr 2002 with shipping number 56565656. The OrderItem Status table is the only one that would change: OrderItemStatus OrderItemStatusID OrderItemID Status StatusDate StatusInfo 1 1 Backorder 2 Apr 2002 Expect by 15 Apr 2002 2 2 Shipped 2 Apr 2002 56565656 Assume the Thingamajig was retuned because of a bad address on 10 Apr 2002:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: OrderItemStatus OrderItemStatusI D OrderItemID Status StatusDate StatusInfo 1 1 Backorder 2 Apr 2002 Expect by 15 Apr 2002 2 2 Shipped 2 Apr 2002 56565656 3 2 Returned 10 Apr 2002 Wrong shipping address Then the Widgets and the Thingamajig were sent back out on 17 Apr 2002: OrderItemStatus OrderItemStatusI D OrderItemID Status StatusDate StatusInfo 1 1 Backorder 2 Apr 2002 Expect by 15 Apr 2002 2 2 Shipped 2 Apr 2002 56565656 3 2 Returned 10 Apr 2002 Wrong shipping address 4 1 Shipped 17 Apr 2002 7777777 5 2 Shipped 17 Apr 2002 7777778 Given this table structure, you can trace the actions taken for each order item and see the complete history of those actions....
View Full Document

Page1 / 2

Order - OrderItemStatus OrderItemStatusI D OrderItemID...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online