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

ItemID StoreID PurchasingAgentID PurchaseDate ItemDescription Category PriceUSD

500 1050 101 12/10/2012 Antique Large Bureaus Furniture $ 13,415.00

505 1050 102 12/12/2012 Porcelain Lamps Lamps $ 13,300.00

510 1200 104 12/15/2012 Gold Rim Design China Tableware $ 38,500.00

515 1200 104 12/16/2012 Gold Rim Design Serving Dishes Tableware $ 3,200.00

4/7/2013 $ 14,300.00

520 1050 102 QE Dining Set Furniture

525 1100 103 5/18/2013 Misc Linen Linens $ 88,545.00

530 1000 103 5/19/2013 Large Masks Decorations $ 22,135.00

535 1100 104 5/20/2013 Willow Design China Tableware $ 147,575.00

540 1100 104 5/20/2013 Willow Design Serving Dishes Tableware $ 12,040.00

545 1150 102 6/14/2013 Woven Goods Decorations $ 1,200.00

101 6/16/2013 Antique Leather Chairs $ 5,375.00

550 1150 Furniture

555 1100 104 7/15/2013 Willow Design Serving Dishes Tableware $ 4,500.00

560 1000 103 7/17/2013 Large Bureau Furniture $ 9,500.00

565 1100 104 7/20/2013 Brass Lamps Lamps $ 1,200.00

Figure 7-51
Sample Data for the MI ItEM table

ShipperName Phone Fax

ShipperID EmailAddress Contact

1 ABC Trans-Oceanic 800-234-5656 800-234-5659 [e-mail] Jonathan

2 International 800-123-8898 800-123-8899 [e-mail] Marylin

3 Worldwide 800-123-4567 800-123-4569 [e-mail] Jose

Figure 7-52
Sample Data for the MI SHIPPEr table