CustomerID Last Name First Name Street City State Zip Phone Email DateofBirth Ed Level Sport Racing
1 Mann Dwight 23 Colby Lane Tacoma WA 98109 2531234333 dmann4@aol.com 8/2/1980 12 Hunting TRUE
2 Porter William 3 Pinehill Rd. Logan UT 84321 4357973322 wport3@yahoo.com 11/24/1971 16 Skiing TRUE
3 Higgins Daniel 38 Ryder Rd. Lincoln NE 68526 4024716950 dan333@hotmail.com 12/30/1967 12 Fishing FALSE
tblCustomer
tblDistributor
Page 1
DistID
Distributor
1
Ben’s Cycles
2
J & J Cycle
3
KB Racing
4
Don’s Off Road
5
WX Cycle
6
Performance Cycles
7
Lightning Cycles
8
All-Terrain Cycle
9
Cycle World
tblModel
ModelID
Model
Manufacturer
1
DRZ400
Suzuki
2
RM250
Suzuki
3
Moto 300
Dirt Bikes
7
Moto 450
Dirt Bikes
8
XR200R
Honda
9
CR250
Honda
tblPurchase
Page 1
TransID
CustomerID
ModelID
Date
DistID
3
1
5
8/11/2011
2
7
1
4
2/12/2012
2
12
4
7
1/12/2012
9
2
5
3
10/5/2011
1
4
6
2
9/22/2010
3
9
9
8
6/28/2011
7
13
10
3
12/5/2011
3
6
2
4
11/2/2011
5