Recruitment System Data Model

[rocky09]

Greetings,

I am by my TL to develop an Recruitment Tool in Access. I tried to make tables and other stuff. But, am not able to find a proper data model. Can any one suggest me a good data model or if any working recruitment sample if possible.

Here are some basic needs:

* When a Candidate Sends his/her resume, our HR will store all the required information in the table let's say "Candidates"

* Once an Interview over, the HR will input their comments and change the status whether selected or not. let's say table : Interview Details

* Others tables should be Interviewers table (as we have more than 10 interviewers from different teams), Team Table, Sub Team Table, Current Opening Jobs.

I am struck in relating all the tables. Please some one guide me.

Thank you in advance,

Regards,

 

[Ranman256]

You don't change the person to a different table, you merely change their status field.
From candidate to interview, etc. Persons never leave the Person table.

Another table would track this persons entries.
What team, sub team, jobs, etc.

 

[rocky09]

You don't change the person to a different table, you merely change their status field.
From candidate to interview, etc. Persons never leave the Person table.

Another table would track this persons entries.
What team, sub team, jobs, etc.

Hi Thank you very much for your reply, So, you are saying I have to move Interviewer details from Interviewer table to Candidate Table?

 

[jdraw]

Not recruitment per se, but an approach to HR support from Barry Williams' site.
http://www.databaseanswers.org/data_models/hr_intro.htm

Please some one guide me.

Write a clear description of what is involved in the "business process(es)" you are trying to automate.
Bounce it off colleagues to ensure it is clear and complete. You have to start with a list of requirements.

See this link for an example of the procedure.

Good luck.

 

[rocky09]

Not recruitment per se, but an approach to HR support from Barry Williams' site.
http://www.databaseanswers.org/data_models/hr_intro.htm



Write a clear description of what is involved in the "business process(es)" you are trying to automate.
Bounce it off colleagues to ensure it is clear and complete. You have to start with a list of requirements.

See this link for an example of the procedure.

Good luck.

Thank you for the links.

 

[jdraw]

Here is an overview of the database design process.
From RogersAccessLibrary, the original book Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design was written by Michael Hernandez.

 

[rocky09]

Here is an overview of the database design process.
From RogersAccessLibrary, the original book Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design was written by Michael Hernandez.

Excellent. Thank you so much for the doc.