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.
Wedel, Thomas L.; Behnezhad, Ali R.; and Gray, Glen L.
"A Data Modeling Case: Writers Guild of America, East,"
Journal of Information Systems Education: Vol. 15
Available at: https://aisel.aisnet.org/jise/vol15/iss1/3