Abstract: This teaching case describes the functionality of an applicant processing system designed for a fictitious hotel chain. The system detailed in the case includes a webform where applicants complete and submit job applications. The system also includes a desktop application used by hotel managers and Human Resources to track applications and process job offers. Both the webform and the desktop application share a centralized database. The case is based on an actual systems development project that students completed for a real hotel chain. Material in the case can be used for assignments in systems analysis and design, database management, and web design courses. Teaching notes, including an entity-relationship diagram (ERD), data dictionary, data flow diagrams, job application form, prototype screenshots, and discussion questions are available through the JISE website.

Keywords: Database design & development, Entity-relationship modeling/diagram, Systems analysis & design, Data flow diagram, Web design & development, Teaching case

Download this article: JISE - Volume 29 Number 1, Page 21.pdf

Recommended Citation: Miller, R. E. & Dunn, P. (2018). Teaching Case: MiHotel: Applicant Processing System Design Case. Journal of Information Systems Education, 29(1), 21-24.