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
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.
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
This question was answered on: Sep 18, 2020
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 .
About this QuestionSTATUS
Sep 18, 2020EXPERT
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).
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.