Journal of Information Systems Education (JISE)

Volume 23

Volume 23 Number 2, Pages 119-128

Summer 2012


Teaching Case
Enhancing Knowledge Integration with REA Modeling in an AIS Project


Sunita Ahlawat
Joyce Vincelette

The College of New Jersey
Ewing, NJ 08628, USA

Abstract: This paper describes a project that can be used as an educational tool to develop student understanding of the interrelated nature of business processes. Since accounting databases involve economic resources, events and transactions, and agents (REA), this project requires coverage of business processes, relational data base concepts, data modeling, and familiarity with MS-Access. During this semester-long project, students learn how data is created, how it is interrelated, how it is stored, and how it may be used for business intelligence. By the assignment of deliverables, students gain a fuller and more accurate understanding of accounting systems and databases that support core business processes than by completing short, disparate exercises. Comprehensive teaching notes and solutions to the required deliverables are provided.

Keywords: Database design & development, Entity-relationship modeling/diagram, Normalization, Business intelligence

Download this article: JISE - Volume 23 Number 2, Page 119.pdf


Recommended Citation: Ahlawat, S. & Vincelette, J. (2012). Teaching Case: Enhancing Knowledge Integration with REA Modeling in an AIS Project. Journal of Information Systems Education, 23(2), pp. 119-128.