Malling' -Breaks Line Numbers E Align Ei Group Rotate Recycle Bin s Orientation Size Columnst Hyphenation Left: 0. Before: 0 pt Position Wrap BringSen -- HyphenationRight:0 Text- Forward- Backward-Pane Dirt Bikes Page Setup Paragraph Case Assignment: Improving Decision Making: Redesigning the Customer Database Software akilla Database deaign; 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, addreas (etreet city, state, zip code). telephone number, model purchased, date of purchase, and distributo. 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 agereesively to its customers. Dirt Bikes Case Assi... 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 leam more about customers' interesta and tastea: their ages, vears ofachooling, 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 purchaaed from Dirt Bikes U.S.A or other manufacturer.) Ifa motoreycle 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 motoscycle ( motorcycles) and the distributor from whom the customer purchased that motorcycle. Redeaign 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 Conaider uaing multiple tables in your new deaign. Populate each new table with 10 records. . Develop at least 5 queries and 5 r reports that would be of great interest to Dirt Bikes's marketing and sales department (for example, lists of repeat Dirt Bikes Diit Bikes cuetomers who attend racing events, o the average ages and years of schooling of Dirt Bikes customers) Page 1 of 1 331 words 8 English (United States) Type here to search 245 PM 9/16/2018 Malling' -Breaks Line Numbers E Align Ei Group Rotate Recycle Bin s Orientation Size Columnst Hyphenation Left: 0. Before: 0 pt Position Wrap BringSen -- HyphenationRight:0 Text- Forward- Backward-Pane Dirt Bikes Page Setup Paragraph Case Assignment: Improving Decision Making: Redesigning the Customer Database Software akilla Database deaign; 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, addreas (etreet city, state, zip code). telephone number, model purchased, date of purchase, and distributo. 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 agereesively to its customers. Dirt Bikes Case Assi... 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 leam more about customers' interesta and tastea: their ages, vears ofachooling, 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 purchaaed from Dirt Bikes U.S.A or other manufacturer.) Ifa motoreycle 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 motoscycle ( motorcycles) and the distributor from whom the customer purchased that motorcycle. Redeaign 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 Conaider uaing multiple tables in your new deaign. Populate each new table with 10 records. . Develop at least 5 queries and 5 r reports that would be of great interest to Dirt Bikes's marketing and sales department (for example, lists of repeat Dirt Bikes Diit Bikes cuetomers who attend racing events, o the average ages and years of schooling of Dirt Bikes customers) Page 1 of 1 331 words 8 English (United States) Type here to search 245 PM 9/16/2018