You can find the database on

http://moodle.mcny.edu/file.php/8178/tasks/hands-on_project/casedatafiles/mis11ch06%20customer%20database.mdb

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.

Note: if you can't use access database, then download and review the customer database in excel format:

http://moodle.mcny.edu/file.php/8178/tasks/hands-on-mis-datafiles/office_2007/tblcustomer.xlsx

You should then suggest new tables that you need besides the customer tables; and also create the new tables in excel. 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.

• Redesign dirt bikes’s customer database (see attachment docment) in order to 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. Consider using multiple tables in your new design. Populate each new table with 10 records.

• Develop several reports that would be of great interest to dirt bikes’s 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 print them.