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), 13-17.