Teaching case MiHotel: Applicant processing system design case

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.