Teaching Case: Design and Development of a Special Population Resource Connection Database

Connecting people with resources is a common activity. However, special situations have unique data needs. Without the appropriate leadership and tools to manage the data, the connections may never take place. This case examines the data needs associated with providing resources and social connections for families having a member with a special need. The case provides a realistic scenario that can be used in a systems analysis and design, database development, or graduate-level management information systems course. The case focuses on developing a database to provide a support system for connecting caregivers of loved ones having special needs with people in similar circumstances, volunteers, and social and employment opportunities. Two assignment options are provided, allowing instructors to select an assignment based on course material coverage. Suggested assignments include the development of process modeling diagrams such as a data flow or swimlane diagrams and database design and development artifacts.