An online recruitment system is a service that automates company’s recruiting needs by getting volumes of employment applications over the internet. The beauty of online recruitment solutions lies in its accessibility and ease of use. Anywhere on the globe, designated individuals are able to receive process and keep a record of CV’s within a web-based information power house. Online recruitment benefits both job seekers and employers. Applicants have a simpler, more efficient application process, while employers are able to manage all applications in an efficient manner. An online recruitment system can include the following functionalities:
- Signing up a new user (e.g. job seeker, employer)
- Updating user details
- Adding/updating a vacancy (by employer)
- Showing a list of vacancies that satisfy certain criteria (e.g. industry, location, required experience…)
- Showing a list of job seekers that satisfy certain criteria (e.g. industry, location, experience…)
- Performing operations on vacancies: apply and save (by job seeker)
- Performing operations on vacancies: hide (by employer)
- What was the most interesting job “title” that had maximum number of applicants?
- What was the announced job “title” that hadn’t any applicants last month?
- Who was the employer with the maximum announcements last month?
- Who were the employers didn’t announce any job last month?
- What were the available positions at each employer last month?
- For each seeker, retrieve all his/her information and the number of jobs he applied for
- Draw the corresponding ERD for this project in a way that answers the corresponding inquires stated in the project.
- Convert the ERD to Physical model (DDL scripts)
- Write SQL statements corresponding to the queries
- Conceptual Model (ERD)
- Physical model
- Set of SQL statements + Snapshot of the results
- Project report containing all deliverables