Question Details

Answered: - Dirt Bikes U.S.A. sells primarily through its distributors


Dirt Bikes U.S.A. sells primarily through its distributors. It maintains a small customer data with the following data: customer name, address (street, city, state, zip code), telephone number, model purchased, date of purchase, and distributor. You can find the example data in the attached file?DirtBikesCustomer.xlsx. These data are collected by its distributors when they make a sale and are then forwarded to Dirt Bikes.

However, this small data doesn?t meet the Marketing Department?s information needs. The Marketing Department 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. Your team is a part of Marketing Department and responsible for designing the new database.

Use Microsoft Access to design a new customer database so that it can store and provide the information needed for marketing. After analyzing the information needs and requirements, your team decided to create four tables in your database. You should name these tables as Customer, Distributor, Model, and Purchase. According to the information requirements, your team determines what fields should be defined in each table. However, each table should have a field as primary key?usually as ID Number. Please give a proper name to each field in a table. Right now you don?t need populating each new table with records; that is, each table should contain all necessary fields with proper names, but without any data. (Your team should not enter data from?DirtBikesCustomer.xlsx?to your new database. These data are just used for example.)




CustomerID Last Name

 

1 Mann

 

2 Porter

 

3 Higgins

 

4 Langan

 

5 Delgado

 

6 Stratman

 

7 Yates

 

8 Mickel

 

9 Podell

 

10 Lowe

 


 

First Name

 

Dwight

 

William

 

Daniel

 

Howard

 

Luis

 

Philip

 

Gerry

 

Paul

 

James

 

Mark

 


 

Street

 

23 Colby Lane

 

3 Pinehill Rd.

 

38 Ryder Rd.

 

8 Belle Ave.

 

66 Skyview Terrace

 

722 Donald Dr.

 

11 Buena Vista Dr.

 

523 Grant St.

 

68 Clinton St.

 

95 Canyon Dr.

 


 

City

 

Tacoma

 

Logan

 

Lincoln

 

Flagstaf

 

Las Cruces

 

Hayward

 

Ventura

 

Norman

 

Pocatello

 

Pomona

 


 

State

 

WA

 

UT

 

NE

 

AZ

 

NM

 

CA

 

CA

 

OK

 

ID

 

CA

 


 

Zip

 

98109

 

84321

 

68526

 

86002

 

88003

 

94541

 

93012

 

73072

 

83202

 

91767

 


 

Phone

 

2531234333

 

4357973322

 

4024716950

 

9283825877

 

5055824301

 

7142785564

 

8054137922

 

4053251971

 

2082514967

 

9098693955

 


 

Model

 

Enduro 250

 

Enduro 250

 

Moto 450

 

Moto 450

 

Moto 300

 

Moto 450

 

Enduro 250

 

Moto 300

 

Enduro 550

 

Moto 300

 


 

Date

 

Distributor

 

2/12/2013 J&J Cycle

 

3/27/2013 WX Cycle

 

7/11/2012 All-Terrain Cycle

 

1/12/2013 Cycle World

 

10/5/2012 Ben's Cycles

 

3/21/2012 Don's Of Road

 

5/16/2013 Lightning Cycles

 

4/17/2013 WX Cycle

 

5/18/2012 Performance Cycles

 

12/5/2012 KB Racing

 


 

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001185477.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now