Database Reference
In-Depth Information
Rep
RepNum
LastName
FirstName
Street
City
State
Zip
Commission
Rate
20
Kaiser
Valerie
624 Randall
Grove
FL
33321
$20,542.50
0.05
35
Hull
Richard
532 Jackson
Sheldon
FL
33553
$39,216.00
0.07
65
Perez
Juan
1626 Taylor
Fillmore
FL
33336
$23,487.00
0.05
156
Customer
CustomerNum
CustomerName
Street
City
State
Zip
Balance
CreditLimit
RepNum
148
Al's Appliance
2837 Greenway
Fillmore
FL
33336
$6,550.00
$7,500.00
20
and Sport
282
Brookings Direct
3827 Devon
Grove
FL
33321
$431.50
$10,000.00
35
356
Ferguson's
382 Wildwood
Northield
FL
33146
$5,785.00
$7,500.00
65
408
The Everything
1828 Raven
Crystal
FL
33503
$5,285.25
$5,000.00
35
Shop
462
Bargains Galore
3829 Central
Grove
FL
33321
$3,412.00
$10,000.00
65
524
Kline's
838 Ridgeland
Fillmore
FL
33336
$12,762.00
$15,000.00
20
608
Johnson's
372 Oxford
Sheldon
FL
33553
$2,106.00
$10,000.00
65
Department
Store
687
Lee's Sport
282 Evergreen
Altonville
FL
32543
$2,851.00
$5,000.00
35
and Appliance
725
Deerield's
282 Columbia
Sheldon
FL
33553
$248.00
$7,500.00
35
Four Seasons
842
All Season
28 Lakeview
Grove
FL
33321
$8,221.00
$7,500.00
20
Orders
OrderLine
OrderNum
OrderDate
CustomerNum
OrderNum
PartNum
NumOrdered
QuotedPrice
21608
10/20/2013
148
21608
AT94
11
$21.95
21610
10/20/2013
356
21610
DR93
1
$495.00
21613
10/21/2013
408
21610
DW11
1
$399.99
21614
10/21/2013
282
21613
KL62
4
$329.95
21617
10/23/2013
608
21614
KT03
2
$595.00
21619
10/23/2013
148
21617
BV06
2
$794.95
21623
10/23/2013
608
21617
CD52
4
$150.00
21619
DR93
1
$495.00
21623
KV29
2
$1,290.00
Part
PartNum
Description
OnHand
Class
Warehouse
Price
AT94
Iron
50
HW
3
$24.95
BV06
Home Gym
45
SG
2
$794.95
CD52
Microwave Oven
32
AP
1
$165.00
DL71
Cordless Drill
21
HW
3
$129.95
DR93
Gas Range
8
AP
2
$495.00
DW11
Washer
12
AP
3
$399.99
FD21
Stand Mixer
22
HW
3
$159.95
KL62
Dryer
12
AP
1
$349.95
KT03
Dishwasher
8
AP
3
$595.00
KV29
Treadmill
9
SG
2
$1,390.00
FIGURE 5-1
Premiere Products data
