Home arrow MySQL arrow Page 3 - The Perfect Job (part 1)

Entry Point - MySQL

Recruitment - the art of matching qualified applications to openpositions within an organization - is one of the most challenging tasks forany Human Resources department. However, powerful open-source tools likePHP and mySQL have made the process simpler, more efficient and moreeconomical than at any time in the past. This case study demonstrates how,by building a complete job listing and resume management system fromscratch.

  1. The Perfect Job (part 1)
  2. An Ideal World
  3. Entry Point
  4. Going To The Database
  5. The Five Rs
  6. Lucky Thirteen
  7. Building The Foundation
  8. The Devil Is In The Details
  9. Applying Yourself
  10. Testing Times
  11. Filing It All Away
By: icarus, (c) Melonfire
Rating: starstarstarstarstar / 4
June 28, 2001

print this article


At this point, I have also come up with a few ideas as to how this system is likely to work.

Conceptually, I can consider this system to be split into two parts: a user section, and an administration section. Here is an initial draft of the basic flow and rules that I plan to build into this application.

1. In the user section, the entry point for a potential job applicant will be a job listing, which will display a list of open positions within the organization. This should, in turn, allow the applicant to select a specific job and obtain detailed information on responsibilities, qualifications, salary and other basic information.

2. The applicant will also have the option to fill up an application form online, and provide the organization with personal information, qualifications, experience and other information typically found in a resume. This data will be stored in a database, accessible and searchable by administrators.

3. In the administration section, administrators will have the option to add, edit and delete job listings.

4. The administration section will also contain a search form, to help administrators search stored applications for specific skills or qualifications.

This article copyright Melonfire 2001. All rights reserved.

>>> More MySQL Articles          >>> More By icarus, (c) Melonfire

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates


Dev Shed Tutorial Topics: