CustomerID CompanyName Address1 Address2 City State Zip

1 Astro Advertising 1 Adams Way Atascadero CA 93422

2 Bearcat Boosters 2 Bounty Blvd Boise ID 83713
3 Cavalier Crafts 3 Clark Dr Clackamas OR 97015
4 Dashing Daisies 4 Duke Drive Downers Grove IL 60515
5 Eastern Eardrums 5 Elm Ave Ellicott City MD 21042
6 Firebird Fire Sprinklers 6 Foster St Falls River MA 02720
7 Grappling Grapes 7 Grove Way Grapevine TX 76051
8 Harry's Hardware 8 Hive St Homedale ID 83628
9 Ichabod's Cranes 9 Icicle Cir Idaho Falls ID 83415
10 Jazzy Jazz Café 10 Juniper Cir Joliet IL 60434
11 Kathy's Kitchen 11 Korver Blvd Kalamazoo MI 49003
12 Larry's Lights 12 Logan St Laredo TX 78040
13 Madeline's Muffins 13 McDonald Way Monterey CA 93943
14 Nelson's New Ads 14 Neptune St Nampa ID 83652
15 Ophelia's Opera House 15 Opal St Oregon City OR 97045
16 Milton's Restaurant 16 Office Drive Oregon City OR 97045
 Phone EMail Active Employee
(805) 555-1234 -1 Brewster
(208) 555-3423 [email protected] -1 Brewster
(503) 555-3890 [email protected] -1 Jones
(630) 555-8977 [email protected] -1 Jones
(227) 555-2456 [email protected] 0
(339) 555-3422 [email protected] Stetson
(817) 555-4443 [email protected] -1 Jones
(208) 555-8797 [email protected] -1 Rogers
(208) 555-3578 [email protected] -1 Rogers
(815) 555-5738 [email protected] 0
(269) 555-3009 [email protected] -1 Stetson
(956) 555-8732 [email protected] -1 Stetson
(831) 555-1299 [email protected] -1 Brewster
(208) 555-4747 [email protected] -1 Towers
(541) 555-2876 [email protected] -1 Towers
(541) 555-3001 [email protected] 0
EmployeeID LastName FirstName Extension
3 Peters Penelope 1003
4 Rogers Robert 1004
5 Stetson Jim 1005
6 Towers Tina 1006
7 Adams Anthony 1007
8 Brewster Barbara 1008
9 Charles Carla 1009
10 Drake Doug 1010
11 Eastman Elmer 1011
12 Flagg Freida 1012
13 Gray George 1013
14 Harris Harriet 1014
15 Ilsa Ilene 1015
16 Jones Jane 1016
17 Krueger Kris 1017
18 Lawson Lila 1018
19 Moore Matthew 1019
20 Nelson Nelly 1020
21 O'Brien Oscar 1021
22 Peters Paula 1022
23 Quick Yolanda 1023
24 Rogers Rita 1024
25 Smith Sammy 1025
26 Tuttle Terry 1026
27 Underwood Ursula 1027
28 Voss Victor 1028
29 Waters William 1029
CategoryID Category
1 Paper
2 Writing Tools
3 Staplers
4 Electronics
5 Folders
OrderDetailID OrderID ProductID Quantity
1 1 FLDGRN 10
2 1 FLDVAN 100
3 2 PAPW20 10
4 3 STPBLK 5
5 3 STPRED 2
6 3 PNBPBL 10
7 3 PNBPBU 10
8 4 RGRSMP 1
9 4 PAPW20 10
10 4 PAPW24 2
11 5 HLTPNK 1
12 5 PAPW24 100
13 6 RGRSMP 2
14 6 RGRDUP 1
15 6 HLTYLW 3
16 7 STPBLK 2
17 7 RGRSMP 2
18 8 PNBPBL 50
19 8 PNBPBU 50
20 9 HLTYLW 3
21 9 HLTPNK 2
22 9 PAPW20 50
23 10 FLDGRN 11
24 10 FLDVAN 22
25 11 PAPW20 500
26 11 PAPW24 25
27 12 STPBLK 4
28 12 HLTYLW 3
29 13 FLDVAN 30
30 13 HLTYLW 5
31 14 PAPW20 100
32 14 PAPW24 20
33 15 PAPW24 20
34 15 PAPW20 80
35 16 FLDVAN 20
36 16 FLDGRN 20
37 17 RGRSMP 1
38 17 PNBPBL 50
39 18 RGRDUP 1
40 19 HLTYLW 3
41 19 HLTPNK 11
42 20 PNBPBU 50
43 20 PNBPBL 30
44 21 PAPW24 30
45 21 PAPW20 30
46 22 HLTYLW 11
47 22 HLTPNK 22
48 22 FLDVAN 33
49 23 FLDGRN 10
50 23 FLDVAN 20
51 24 PAPW20 50
52 25 PAPW20 30
53 25 STPBLK 2
54 26 STPBLK 2
55 26 PAPW20 22
56 27 FLDVAN 20
57 27 FLDGRN 5
58 28 FLDGRN 20
59 28 FLDVAN 80
60 28 PAPW20 50
61 29 HLTPNK 30
62 30 STPRED 2
63 30 PNBPBL 50
OrderID CustomerID OrderDate ShipDate
1 Astro Advertising 26-May-10 28-May-10
2 Astro Advertising 02-Jun-10 03-Jun-10

3 Firebird Fire Sprinklers 09-Jun-10 10-Jun-10

4 Grappling Grapes 14-Jun-10 15-Jun-10

5 Firebird Fire Sprinklers 14-Jun-10 16-Jun-10

6 Dashing Daisies 15-Jun-10 16-Jun-10

7 Kathy's Kitchen 16-Jun-10 17-Jun-10
8 Larry's Lights 18-Jun-10 20-Jun-10
9 Astro Advertising 19-Jun-10 20-Jun-10
10 Bearcat Boosters 20-Jun-10 22-Jun-10
11 Cavalier Crafts 22-Jun-10 23-Jun-10
12 Astro Advertising 24-Jun-10 26-Jun-10
13 Dashing Daisies 26-Jun-10 28-Jun-10
14 Madeline's Muffins 29-Jun-10 30-Jun-10
15 Astro Advertising 01-Jul-10 02-Jul-10
16 Grappling Grapes 02-Jul-10 06-Jul-10
17 Harry's Hardware 06-Jul-10 08-Jul-10
18 Ichabod's Cranes 08-Jul-10 11-Jul-10
19 Larry's Lights 09-Jul-10 11-Jul-10

20 Firebird Fire Sprinklers 12-Jul-10 14-Jul-10

21 Astro Advertising 15-Jul-10 17-Jul-10

22 Cavalier Crafts 17-Jul-10 18-Jul-10
23 Bearcat Boosters 18-Jul-10 20-Jul-10
24 Ichabod's Cranes 20-Jul-10 22-Jul-10
25 Kathy's Kitchen 21-Jul-10 22-Jul-10
26 Ichabod's Cranes 23-Jul-10 24-Jul-10
27 Madeline's Muffins 25-Jul-10 27-Jul-10
28 Astro Advertising 26-Jul-10 28-Jul-10
29 Astro Advertising 27-Jul-10
30 Milton's Restaurant 01-Aug-10
 ProductID ProductName Price ProductManual CategoryID
FLDGRN Green Folders $2.00 0 Folders
FLDVAN Vanilla Folders $1.59 0 Folders
HLTPNK Pink Highlighter $1.50 0 Writing Tools
HLTYLW Yellow Highlighter $1.50 0 Writing Tools
PAPBLU Blue Paper $5.00 0 Paper
PAPW20 White Paper 20pt $3.00 0 Paper
PAPW24 White Paper 24pt $3.10 0 Paper
PNBPBL Black Ball-Point Pen $0.99 0 Writing Tools
PNBPBU Blue Ball-Point Pen $0.99 0 Writing Tools
RGRDUP Super Duper Cash Register $299.00 1 Electronics
RGRSMP Simple Cash Register $99.00 1 Electronics
STPBLK Black Stapler $2.80 0 Staplers
STPRED Red Stapler $3.00 0 Staplers