MIS Case Study using Microsoft Access Database

profileOB91
caseassignment3_databsae.mdb
Home>Information Systems homework help>MIS Case Study using Microsoft Access Database
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 [email protected] 8/2/80 12 Hunting true
2 Porter William 3 Pinehill Rd. Logan UT 84321 4357973322 [email protected] 11/24/71 16 Skiing true
3 Higgins Daniel 38 Ryder Rd. Lincoln NE 68526 4024716950 [email protected] 12/30/67 12 Fishing false
4 Langan Howard 8 Belle Ave. Flagstaff AZ 86002 9283825877 [email protected] 6/26/66 14 Hunting true
5 Delgado Luis 66 Skyview Terrace Las Cruces NM 88003 5055824301 7/22/61 12 Football true
6 Stratman Philip 722 Donald Dr. Hayward CA 94541 7142785564 [email protected] 2/16/74 16 Tennis false
7 Yates Gerry 11 Buena Vista Dr. Ventura CA 93012 8054137922 [email protected] 6/6/79 12 Skiing false
8 Mickel Paul 523 Grant St. Norman OK 73072 4053251971 4/1/78 14 Hunting true
9 Podell James 68 Clinton St. Pocatello ID 83202 2082514967 [email protected] 3/8/72 18 Tennis false
10 Lowe Mark 95 Canyon Dr. Pomona CA 91767 9098693955 [email protected] 10/18/69 16 Skiing false
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
ModelID Model Manufacturer
1 DRZ400 Suzuki
2 RM250 Suzuki
3 Moto 300 Dirt Bikes
4 Enduro 250 Dirt Bikes
5 Enduro 550 Dirt Bikes
6 KDX200 Kawasaki
7 Moto 450 Dirt Bikes
8 XR200R Honda
9 CR250 Honda
TransID CustomerID ModelID Date DistID
1 3 3 6/7/12 7
2 5 3 10/5/11 1
3 1 5 8/11/11 2
4 6 2 9/22/10 3
5 6 7 3/21/11 4
6 2 4 11/2/11 5
7 1 4 2/12/12 2
8 9 5 5/18/11 6
9 9 8 6/28/11 7
10 3 7 7/11/12 8
11 2 9 3/27/12 5
12 4 7 1/12/12 9
13 10 3 12/5/11 3
14 8 3 4/17/12 5
15 7 4 5/16/11 7