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

ShipmentItemID PurchaseItemID InsuredValue

ShipmentID

100 1 500 $15,000.00

100 2 505 $15,000.00

101 1 510 $40,000.00

101 2 515 $3,500.00

102 1 520 $15,000.00

103 1 525 $90,000.00

2 530 $25,000.00

103

535

103 3 $150,000.00

103 4 540 $12,500.00

104 1 545 $12,500.00

104 2 550 $5,500.00

105 1 555 $4,500.00

Figure 7-54
Sample Data for the
MI SHIPMENt_ItEM table

105 2 560 $10,000.00

105 3 565 $1,500.00

ReceiptNumber ShipmentID ItemID ReceivingAgentID ReceiptDate ReceiptTime ReceiptQuantity isReceivedUndamaged amageNotes

200001 3 Yes NULL

100 500 105 17-Mar-13 10:00 AM

200002 NULL

100 505 105 17-Mar-13 10:00 AM 50 Yes

200003 101 510 105 23-Mar-13 3:30 PM 100 Yes NULL

200004 101 515 105 23-Mar-13 3:30 PM 10 Yes NULL

One leg on one
chair broken.

200005 102 520 106 19-Jun-13 10:15 AM 1 No

200006 103 525 106 20-Jul-13 2:20 AM 1000 Yes NULL

200007 103 530 106 20-Jul-13 2:20 AM 100 Yes NULL

200008 103 535 106 20-Jul-13 2:20 AM 100 Yes NULL

200009 103 540 106 20-Jul-13 2:20 AM 10 Yes NULL

200010 104 545 105 29-Jul-13 9:00 PM 100 Yes NULL

200011 104 29-Jul-13 9:00 PM 5 Yes

550 105 NULL

200012 105 106 14-Sep-13 2:45 PM 4 Yes NULL

555

200013 105 560 106 14-Sep-13 2:45 PM 1 Yes NULL

Base of one lamp
scratched

200014 105 565 106 14-Sep-13 2:45 PM 10 No

Figure 7-55
Sample Data for the
MI SHIPMENt_rECEIPt
table