Treffer: Kibbles & Bytes: Developing a Database for an Animal Shelter Silent Auction

Many nonprofit organizations rely upon volunteers and fundraising events to supplement their operating budgets. Unfortunately, these budgets are often so tight that they do not allow for supplemental purchases beyond daily operations. Many nonprofit organizations would love to have volunteer help who could create software to meet their specific needs. However, many do not think to contact local universities for interns or class projects to help them with their needs. Thus, faculty looking for realworld projects to incorporate into their classrooms are often not aware of the needs in their community nor whom to contact. In this teaching case, the students are asked to design and develop a database to support a silent auction fundraising event. System needs and requirements are presented in a conversational format simulating the client requirements interview process. The case can be used in a systems analysis and design, database development or graduate level management information systems course. The case focuses upon the development of a donation management system for a small silent auction with donors, donations, and auction attendees. Multiple assignment options are provided, allowing instructors to select an assignment based upon course material coverage. Suggested assignments include the development of process modeling diagrams such as data flow and swim lane diagrams, database design diagrams such as UML diagrams or ERDs, and database artifacts such as tables, queries, and reports.

As Provided