SQL for Database Construction and Application Processing - Database Processing: Fundamentals, Design, and Implementation - page 364

ActualDepartureDate

ShipmentID ShipperID PurchasingAgentID ShipperInvoiceNumber Origin Destination ScheduledDepartureDate EstimatedArrivalDate

100 1 103 2010651 Manila Los Angeles 10-Dec-12 10-Dec-12 15-Mar-13

101 1 104 2011012 Hong Kong Seattle 10-Jan-13 12-Jan-13 20-Mar-13

49100300 05-May-13 05-May-13 17-Jun-13

102 3 103 Manila Los Angeles

103 2 104 399400 Singapore Portland 02-Jun-13 04-Jun-13 17-Jul-13

104 3 103 84899440 Lima Los Angeles 10-Jul-13 10-Jul-13 28-Jul-13

104 488955 05-Aug-13 09-Aug-13 11-Sep-13

105 2 Singapore Portland

Figure 7-53
Sample Data for the MI SHIPMENt table