Introduction to Structured Query Language - Database Processing: Fundamentals, Design, and Implementation - page 112

ItemID ItemDescription CompanyName PurchaseDate ItemCost ItemPrice

1 Antique Desk European Specialties 11/7/2012 $1,800.00 $3,000.00

2 Antique Desk Chair

Andrew Lee 11/10/2012 $300.00 $500.00

3 Dining Table Linens Linens and Things 11/14/2012 $600.00 $1,000.00

4 Candles

Linens and Things 11/14/2012 $30.00 $50.00

5 Candles Linens and Things 11/14/2012 $27.00 $45.00

6 Desk Lamp $150.00 $250.00

Lamps and Lighting 11/14/2012

7 Dining Table Linens Linens and Things 11/14/2012 $450.00 $750.00

8 Book Shelf $150.00 $250.00

Denise Harrion 11/21/2012

9 Antique Chair New York Brokerage 11/21/2012 $750.00 $1,250.00

10 Antique Chair New York Brokerage 11/21/2012 $1,050.00 $1,750.00

11 Antique Candle Holder European Specialties 11/28/2012 $210.00 $350.00

12 Antique Desk European Specialties 1/5/2013 $1,920.00 $3,200.00

13 Antique Desk European Specialties 1/5/2013 $2,100.00 $3,500.00

14 Antique Desk Chair Specialty Antiques 1/6/2013 $285.00 $475.00

15 Antique Desk Chair 1/6/2013 $339.00 $565.00

Specialty Antiques

16 Desk Lamp General Antiques 1/6/2013 $150.00 $250.00

17 Desk Lamp $150.00 $250.00

General Antiques 1/6/2013

18 Desk Lamp Lamps and Lighting 1/6/2013 $144.00 $240.00

19 Antique Dining Table $3,000.00 $5,000.00

Denesha Walsh 1/10/2013

20 Antique Sideboard Chris Bancroft 1/11/2013 $2,700.00 $4,500.00

21 Dining Table Chairs $5,100.00 $8,500.00

Specialty Antiques 1/11/2013

22 Dining Table Linens Linens and Things 1/12/2013 $450.00 $750.00

23 Dining Table Linens $480.00 $800.00

Linens and Things 1/12/2013

24 Candles Linens and Things 1/17/2013 $30.00 $50.00

25 Candles Linens and Things 1/17/2013 $36.00 $60.00

Figure 2-49
QACS Database ITEM Table