13-11 This project requires you to perform a systems analysis and then design a system solution using database software.

Burrows Auto Dealers specializes in selling new vehicles from Toyota in Sheffield, England. The company advertises in local newspapers and is listed as an authorized dealer on the Toyota Web site and other major Web sites for auto buyers. The company benefits from a good local word-of-mouth reputation and name recognition.

Burrows 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 Burrows from newspaper ads, from word of mouth, or from the Web?

Prepare a systems analysis report detailing Burrows’ problem and a system solution that can be implemented using PC database management software. Then use database software to develop a simple system solution.