LAB

CustomerNumber

CustomerNumber FirstName LastName Phone Email

1 Nikki Kaccaton 723-543-1233 [email protected]

2 Brenda Catnazaro 723-543-2344 [email protected]

3 Bruce LeCat 723-543-3455 [email protected]

4 Betsy Miller 725-654-3211 [email protected]

5 George Miller 725-654-4322 [email protected]

6 Kathy Miller 723-514-9877 [email protected]

7 Betsy Miller 723-514-8766 [email protected]

Invoice

InvoiceNumber CustomerNumber DateIn DateOut TotalAmount

201101 1 10/4/2013 10/6/2013 $158.50

201102 2 10/4/2013 10/6/2013 $25.00

201103 1 10/6/2013 10/8/2013 $49.00

201104 4 10/6/2013 10/8/2013 $17.50

201105 6 10/7/2013 10/11/2013 $12.00

201106 3 10/11/2013 10/13/2013 $152.50

201107 3 10/11/2013 10/13/2013 $7.00

201108 7 10/12/2013 10/14/2013 $140.50

201109 5 10/12/2013 10/14/2013 $27.00

Invoice_Item

ItemNumber InvoiceNumber Item Quantity UnitPrice

1 201101 Blouse 2 $3.50

2 201101 Dress Shirt 5 $2.50

3 201101 Formal Gown 2 $10.00

4 201101 Slacks-Mens 10 $5.00

5 201101 Slacks-Womens 10 $6.00

6 201102 Suit-Mens 1 $9.00

7 201102 Dress Shirt 10 $2.50

8 201103 Slacks-Mens 5 $5.00

9 201103 Slacks-Womens 4 $6.00

10 201104 Dress Shirt 7 $2.50

11 201105 Blouse 2 $3.50

12 201105 Dress Shirt 2 $2.50

13 201106 Blouse 5 $3.50

14 201106 Dress Shirt 10 $2.50

15 201106 Slacks-Mens 10 $5.00

16 201106 Slacks-Womens 10 $6.00

17 201107 Blouse 2 $3.50

18 201108 Blouse 3 $3.50

19 201108 Dress Shirt 12 $2.50

20 201108 Slacks-Mens 8 $5.00

21 201108 Slacks-Womens 10 $6.00

22 201109 Suit-Mens 3 $9.00