Modeling a Business Process and Querying the Resulting Database: Analyzing RFID Data to Develop Business Intelligence
Authors:
- A. Faye BorthickABA. Faye Borthick
- Paul L. BowenPBPaul L. Bowen
- Gregory J. GerardGGGregory J. Gerard
- A. Faye Borthick, Paul L. Bowen, Gregory J. GerardGeorgia State UniversityFlorida State UniversityFlorida State UniversityAUA. Faye Borthick, Paul L. Bowen, Gregory J. GerardGeorgia State UniversityFlorida State UniversityFlorida State University
- Ron WeberRWRon Weber
- Kevin E. DowKDKevin E. Dow
- Marcia Weidenmier WatsonMWMarcia Weidenmier Watson
- Vincent J. SheaVSVincent J. Shea
- James L. WorrellJWJames L. Worrell
- Gary P. SchneiderGSGary P. Schneider
- Anthony O. VanceAVAnthony O. Vance
- 1 September 2008
- journal article
- Published by American Accounting Association in Journal of Information Systems
- Vol. 22 (2) , 331-350
Abstract
This case supports the high-level objective of learning to model business situations to design databases and query them to solve business problems. Students analyze Radio Frequency Identification (RFID) and related fulfillment data to develop business intelligence for a grower of bedding plants selling to big-box retailers. Students prepare a business process diagram to understand the business process; identify objectives for detecting and correcting data errors and analyzing business performance; construct a Resource, Event, Agent (REA) diagram to specify a database design; implement the database and query it to satisfy business objectives; communicate results; document data error correction procedures; and prepare adjusting journal entries. The case is appropriate for students with moderate database querying proficiency. The case's managerial and financial accounting and internal control implications make it suitable for courses in Accounting Information Systems (AIS) and database systems for advanced undergraduate students and in AIS, database, and managerial courses for master's students. The data are supplied in Microsoft Access® databases.Keywords
This publication has 20 references indexed in Scilit:
- System Diagramming Techniques: An Analysis of Methods Used in Accounting Education and PracticeJournal of Information Systems, 2007
- Creating a Business Process Diagram and Database Queries to Detect Billing Errors and Analyze Calling Patterns for Cell Phone ServiceJournal of Information Systems, 2007
- Auto-IDCommunications of the ACM, 2005
- Analyzing a Potential Warranty Call Center Budget Overrun: Using Database Queries to Solve Business ProblemsJournal of Information Systems, 2005
- Developing Database Query Proficiency: Assuring Compliance for Responses to Web Site ReferralsJournal of Information Systems, 2001
- Data Warehousing Supports Corporate Strategy at First American Corporation1, 2MIS Quarterly, 2000
- Augmented Intensional Reasoning in Knowledge-Based Accounting SystemsJournal of Information Systems, 2000
- Language comprehension: Archival memory or preparation for situated action?Discourse Processes, 1999
- Two decades of structure buildingDiscourse Processes, 1997
- The entity-relationship model—toward a unified view of dataACM Transactions on Database Systems, 1976