Abstract: The value of case studies and other active learning methodologies for teaching systems analysis, database design and program design have been acknowledged and empirically demonstrated. Appropriate case studies challenge students to think analytically and apply information systems concepts and tools to real-world situations. This paper presents a case study that facilitates students to hone their skills in developing data flow diagrams, data modeling, normalized data design, user interface design and modular program design. The case is well suited for a course in Systems Analysis and Design, Database or a course dealing with information systems Applications Development. Students are required to utilize their data flow, modeling and design skills to develop an appropriate data and program structure for the Directors Guild of America Health Plan. While the case realistically details the requirements for health coverage eligibility at DGA Health Plan, other system requirements have been simplified so that the case is not overwhelming. Student feedback indicates that the case is realistic, engaging and challenging without being excessively complex. The case has been used successfully as both group and individual projects. Suggested student deliverables include data flow and normalized entity-relationship diagrams, screen and report layouts, program structure chart and sample pseudo code.
Keywords: Case study, Entity-relationship modeling/diagram, Normalization, Program assessment & design, Structured query language, Systems analysis & design, User requirements.
Download this article: JISE - Volume 23 Number 2, Page 129.pdf
Recommended Citation: Sankaran, S. & Wedel, T. L. (2012). Teaching Case: Directors Guild of America Health Plan Eligibility: An IS Analysis and Design Case. Journal of Information Systems Education, 23(2), pp. 129-132.