Affiliation:
1. Associate Professor at North Carolina State University.
2. Assistant Professor at Arizona State University, West Campus.
3. Lecturer at Arizona State University, West Campus.
Abstract
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.
Publisher
American Accounting Association
Reference13 articles.
1. American Institute of Certified Public Accountants (AICPA). 1996. Information Technology Competencies in the Accounting Profession: AICPA Implementation Strategies for IFAC International Education Guideline No. 11: Implications for Education and Practice. New York, NY: AICPA.
2. American Institute of Certified Public Accountants (AICPA). 1999. AICPA Core Competency Framework for Entry into the Accounting Profession. New York, NY: AICPA.
3. Developing Database Query Proficiency: Assuring Compliance for Responses to Web Site Referrals
4. Creating a Business Process Diagram and Database Queries to Detect Billing Errors and Analyze Calling Patterns for Cell Phone Service
Cited by
8 articles.
订阅此论文施引文献
订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献