Journal of Information Systems Education (JISE)

Volume 15

Volume 15 Number 1, Pages 13-17

Spring 2004


Teaching Case
A Data Modeling Case: Writers Guild of America, East


Thomas L. Wedel
Ali R. Behnezhad
Glen L. Gray

California State University - Northridge
Northridge, CA, USA

Abstract: This article presents a case study that was developed as an instructional case for teaching systems analysis and database design. Students are required to utilize their data modeling skills to design an appropriate data structure for the Writers Guild of America, East (WGAE). The core application in the case is an accounts receivable system, but with several unique features that necessitate creative thought by the student analysts. The case has been used successfully as both group and individual projects. Student feedback indicates that the WGAE Case is realistic, engaging and challenging without being excessively complex. Teaching notes and a suggested solution consisting of an entity-relationship diagram (ERD) and the associated list of entities and attributes are available through the JISE web site.

Keywords: Systems analysis & design, Database design, Case study, Entity relationship diagram

Download this article: JISE - Volume 15 Number 1, Page 13.pdf


Recommended Citation: Wedel, T. L., Behnezhad, A. R., & Gray, G. L. (2004). Teaching Case: A Data Modeling Case: Writers Guild of America, East. Journal of Information Systems Education, 15(1), pp. 13-17.