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 You can find the database posted right below this case in Canvas This data is 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 email 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 nonDirt 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 Leave it blank or make it up Redesign Dirt Bikes customer database so that it can store and provide the information needed for marketing You will need to develop a design for the new customer database and then implement that design using database software You can use multiple tables in your new design if you like Populate each new table with 10 records It doesnt have to be perfect Develop several reports that would be of great interest to Dirt Bikes marketing and sales department (for example, lists of repeat Dirt Bikes customers, Dirt Bikes customers who attend racing events, or the average ages and years of schooling of Dirt Bikes customers) and then copy and paste them in your presentation Tables tblCustomer CustomerID Last Name, First Name, Street City State Zip phone Model Date , Distributor Click to Dwight William Daniel Howard Luis Philip 23 Colby Lane Tacoma 3 Pinehill Rd Logarn 38 Ryder Rd Lincoln 8 Belle Ave Flagstaff 66 Skyview Ter Las Cruces NM 722 Donald Dr HaywardCA 11 Buena Vista Ventura 523 Grant St Norman 68 Clinton St Pocatello 95 Canyon Dr Pomona 2 12 2016 J J Cycle 3 27 2016 WX Cycle 7 11 2015 All Terrain Cyc 1 12 2016 Cycle World 10 5 2015 Ben's Cycles 3 21 2015 Don's Off Road 5 16 2016 Lightning Cycle 4 17 2016 WX Cycle 5 18 2015 Performance C 12 5 2015 KB Racing WA UT NE AZ 98109 2 Porter 3 Higgins 4 Langan 5 Delgado 6 Stratman 7 Yates 8 Mickel 9 Podell 68526 86002 88003 94541 93012 73072 83202 91767 (253) 123 4333 Enduro 250 435) 797 3322 Enduro 250 (402) 471 6950 Moto 450 928) 382 5877 Moto 450 (505) 582 4301 Moto 300 (714) 278 5564 Moto 450 (805) 413 7922 Enduro 250 (405) 325 1971 Moto 300 (208) 251 4967 Enduro 550 (909) 869 3955 Moto 300 CA OK ID CA Paul James 10 Lowe (New) Tables tblCustomer CustomerID Last Name, First Name, Street City State Zip phone Model Date , Distributor Click to Dwight William Daniel Howard Luis Philip 23 Colby Lane Tacoma 3 Pinehill Rd Logarn 38 Ryder Rd Lincoln 8 Belle Ave Flagstaff 66 Skyview Ter Las Cruces NM 722 Donald Dr HaywardCA 11 Buena Vista Ventura 523 Grant St Norman 68 Clinton St Pocatello 95 Canyon Dr Pomona 2 12 2016 J J Cycle 3 27 2016 WX Cycle 7 11 2015 All Terrain Cyc 1 12 2016 Cycle World 10 5 2015 Ben's Cycles 3 21 2015 Don's Off Road 5 16 2016 Lightning Cycle 4 17 2016 WX Cycle 5 18 2015 Performance C 12 5 2015 KB Racing WA UT NE AZ 98109 2 Porter 3 Higgins 4 Langan 5 Delgado 6 Stratman 7 Yates 8 Mickel 9 Podell 68526 86002 88003 94541 93012 73072 83202 91767 (253) 123 4333 Enduro 250 435) 797 3322 Enduro 250 (402) 471 6950 Moto 450 928) 382 5877 Moto 450 (505) 582 4301 Moto 300 (714) 278 5564 Moto 450 (805) 413 7922 Enduro 250 (405) 325 1971 Moto 300 (208) 251 4967 Enduro 550 (909) 869 3955 Moto 300 CA OK ID CA Paul James 10 Lowe (New)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 22, 2024

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

image text in transcribed

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. You can find the database posted right below this case in Canvas. This data is 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 email 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 nonDirt 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. Leave it blank or make it up.

Redesign Dirt Bikes customer database so that it can store and provide the information needed for marketing. You will need to develop a design for the new customer database and then implement that design using database software. You can use multiple tables in your new design if you like. Populate each new table with 10 records. It doesnt have to be perfect.
Develop several reports that would be of great interest to Dirt Bikes marketing and sales department (for example, lists of repeat Dirt Bikes customers, Dirt Bikes customers who attend racing events, or the average ages and years of schooling of Dirt Bikes customers) and then copy and paste them in your presentation.

Tables tblCustomer CustomerID Last Name, First Name, Street City . State . Zip phone | Model Date , Distributor Click to Dwight William Daniel Howard Luis Philip 23 Colby Lane Tacoma 3 Pinehill Rd. Logarn 38 Ryder Rd. Lincoln 8 Belle Ave. Flagstaff 66 Skyview Ter Las Cruces NM 722 Donald Dr. HaywardCA 11 Buena Vista Ventura 523 Grant St. Norman 68 Clinton St. Pocatello 95 Canyon Dr. Pomona 2/12/2016 J&J Cycle 3/27/2016 WX Cycle 7/11/2015 All-Terrain Cyc 1/12/2016 Cycle World 10/5/2015 Ben's Cycles 3/21/2015 Don's Off Road 5/16/2016 Lightning Cycle 4/17/2016 WX Cycle 5/18/2015 Performance C 12/5/2015 KB Racing WA UT NE AZ 98109 2 Porter 3 Higgins 4 Langan 5 Delgado 6 Stratman 7 Yates 8 Mickel 9 Podell 68526 86002 88003 94541 93012 73072 83202 91767 (253) 123-4333 Enduro 250 435) 797-3322 Enduro 250 (402) 471-6950 Moto 450 928) 382-5877 Moto 450 (505) 582-4301 Moto 300 (714) 278-5564 Moto 450 (805) 413-7922 Enduro 250 (405) 325-1971 Moto 300 (208) 251-4967 Enduro 550 (909) 869-3955 Moto 300 CA OK ID CA Paul James 10 Lowe (New) Tables tblCustomer CustomerID Last Name, First Name, Street City . State . Zip phone | Model Date , Distributor Click to Dwight William Daniel Howard Luis Philip 23 Colby Lane Tacoma 3 Pinehill Rd. Logarn 38 Ryder Rd. Lincoln 8 Belle Ave. Flagstaff 66 Skyview Ter Las Cruces NM 722 Donald Dr. HaywardCA 11 Buena Vista Ventura 523 Grant St. Norman 68 Clinton St. Pocatello 95 Canyon Dr. Pomona 2/12/2016 J&J Cycle 3/27/2016 WX Cycle 7/11/2015 All-Terrain Cyc 1/12/2016 Cycle World 10/5/2015 Ben's Cycles 3/21/2015 Don's Off Road 5/16/2016 Lightning Cycle 4/17/2016 WX Cycle 5/18/2015 Performance C 12/5/2015 KB Racing WA UT NE AZ 98109 2 Porter 3 Higgins 4 Langan 5 Delgado 6 Stratman 7 Yates 8 Mickel 9 Podell 68526 86002 88003 94541 93012 73072 83202 91767 (253) 123-4333 Enduro 250 435) 797-3322 Enduro 250 (402) 471-6950 Moto 450 928) 382-5877 Moto 450 (505) 582-4301 Moto 300 (714) 278-5564 Moto 450 (805) 413-7922 Enduro 250 (405) 325-1971 Moto 300 (208) 251-4967 Enduro 550 (909) 869-3955 Moto 300 CA OK ID CA Paul James 10 Lowe (New)