jhoelesmejarda
Registered User.
- Local time
- Today, 18:27
- Joined
- Jan 10, 2013
- Messages
- 26
Hello everyone,
I would like to seek help from guru's here in the forum.
I am currently working on a Database design which is base from an excel file that I have been using, the file was just handed over to me.
So the purpose of this database is mainly,
The recruitment tracking database tracks manpower requirements of the project base on their required number of candidates needed for a specific job title per department. Store candidate information, request (salary or availability), status, progress on his deployment, arrival and exit date, store agency information. Can show numbers of candidates who proceed on their selection, back out from their selection, pass their medical, can proceed to visa application, visa issuance, ticketing and then arrival.
Things that I want my database to react on my data,
I attached a picture of my (so-called) database table relationship created from excel.
I just want to know more, learn more from your comments and suggestions. Thanks in advance!
I would like to seek help from guru's here in the forum.
I am currently working on a Database design which is base from an excel file that I have been using, the file was just handed over to me.
So the purpose of this database is mainly,
The recruitment tracking database tracks manpower requirements of the project base on their required number of candidates needed for a specific job title per department. Store candidate information, request (salary or availability), status, progress on his deployment, arrival and exit date, store agency information. Can show numbers of candidates who proceed on their selection, back out from their selection, pass their medical, can proceed to visa application, visa issuance, ticketing and then arrival.
Things that I want my database to react on my data,
- Store job post requirements by departments, how many candidates needed for that specific job title.
- Store selected candidate information for the required job post.
- Can update, track changes on candidates's information, progress, deployment up to being an hired by the company.
- Can track how many candidates are selected on a specific job title in each department by date (total count and list of names).
- Can track/count how many candidates should be selected base on the demand, number of candidates that was selected and the balance for each position. (selected - demand = balance, total count and list of names)
- Can track how many selected candidates fail (e.g. back out from the selection, fail to pass the medical, other reasons. Total count and list of names)
- Can track how many selected candidates proceed on their employment up to being employed in the project until they leave the project (total count and list of names)
- Can track how many selected candidates pass their medical (total count and list of names)
- Can track how many selected candidates can proceed in applying their visa (total count and list of names)
- Can track how many selected candidates have their visa issued (total count and list of names)
I attached a picture of my (so-called) database table relationship created from excel.
I just want to know more, learn more from your comments and suggestions. Thanks in advance!