Chat with us, powered by LiveChat Kindly find attached the requirements in the attachments CustomerID Last Name First Name Street | Office Paper
+1(978)310-4246 credencewriters@gmail.com
  

Kindly find attached the requirements in the attachments 

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

Chapter 6 Running Case Assignment: Improving Decision Making:

Redesigning the Customer Database

Software skills: Database design; querying and reporting

Business skills: Customer profiling

Dirt Bikes U.S.A. sells primarily through its distributors. It maintains a

small customer database with the following data: customer name, address

(street, city, state, zip code), telephone number, model purchased, date of

purchase, and distributor. These data are collected by its distributors when

they make a sale and are then forwarded to Dirt Bikes. Dirt Bikes would like

to be able to market more aggressively to its customers.

The Marketing Department would like to be able to send customers e-

mail notices of special racing events and of sales on parts. It would also like

to learn more about customers’ interests and tastes: their ages, years of

schooling, another sport in which they are interested, and whether they

attend dirt bike racing events. Additionally, Dirt Bikes would like to know

whether customers own more than one motorcycle. (Some Dirt Bikes

customers own two or three motorcycles purchased from Dirt Bikes U.S.A.

or other manufacturer.) If a motorcycle was purchased from Dirt Bikes, the

company would like to know the date of purchase, model purchased, and

distributor. If the customer owns a non–Dirt Bikes motorcycle, the company

would like to know the manufacturer and model of the other motorcycle (or

motorcycles) and the distributor from whom the customer purchased that

motorcycle. Dirt Bikes’s customer database was redesigned so that it can

store and provide the information needed for marketing.

Case Questions:

Develop the following queries and reports that would be of great interest to

Dirt Bikes’s marketing and sales department.

1- Create a report of customers and motorcycles model grouped by

manufacturer.

2- Create a query about Dirt Bikes customers who attend racing events.

3- Create a query of the customers who have more than 12 years of

education.

error: Content is protected !!