This project requires you to perform a systems analysis and then design a system solution using database software.
Ace Auto Dealers specializes in selling new vehicles from Subaru in Portland, Oregon. The company advertises in local newspapers and is listed as an authorized dealer on the Subaru website and other major websites for auto buyers. The company benefits from a good local word-of-mouth reputation and name recognition.
Ace does not believe it has enough information about its customers. It cannot easily determine which prospects have made auto purchases, nor can it identify which customer touch points have produced the greatest number of sales leads or actual sales so it can focus advertising and marketing more on the channels that generate the most revenue. Are purchasers discovering Ace from newspaper ads, from word of mouth, or from the web?
Prepare a systems analysis report detailing Ace's problem and a system solution that can be implemented using PC database management software. Then use database software to develop a simple system solution. In MyMISLab™, you will find more information about Ace and its information requirements to help you develop the solution.