In this case, you will examine imprecisely stated management problems and decide what data are needed from disparate legacy systems to solve these problems. The general management issues at Beta Auto Dealers, the car dealership in this case, include sales, marketing, and customer visit information. Since data are stored in multiple information systems built upon outdated flat file architecture, management questions cannot be easily answered.

This case encourages you to demonstrate your skills in both information system design and use. Given data extracted from the “legacy systems” in Microsoft® Excel worksheets, you will create business process maps, use your accounting and business knowledge to determine querying objectives for Beta's management, design a conceptual data model, create a Microsoft® Access database, and import data. Finally, using your database query skills, you will build relevant queries and interpret their results in order to improve management's decision making.

This content is only available as a PDF.
You do not currently have access to this content.