Instructor Resource
Kavanagh and Johnson, Human Resource Information Systems: Basics, Applications, and Future Directions, 4e
SAGE Publishing, 2018
Case Notes
Chapter 2: Database Concepts and Applications in HRIS
Applicant Database
Case Summary
The students are asked to create an applicant database for a small recruiting firm that specializes
Case Analysis
Most HRIS rely on an underlying database. Understanding how database systems work,
therefore, is relevant to HR decision makers because knowledge about how to create, store, and
Sample Answers to Case Questions
1. You have been asked to create an applicant database for a small recruiting firm that specializes
in recruiting HR professionals for small to medium firms. Describe the process that you would
use to design this database. Use MS Access to develop a prototype of the database that you could
show your manager.
In general, the database design process can be broken down into several steps that
Instructor Resource
Kavanagh and Johnson, Human Resource Information Systems: Basics, Applications, and Future Directions, 4e
SAGE Publishing, 2018
that entity.
♦ Determine how the tables are related to one another and include common keys.