sql jobsite database sample

Tragiccomic's Avatar, Join Date: Mar 2007
Newbie Member
Hi Everyone,
Im a student in BCA 4th Sem and im working on a Jobsite Project. I am Having confusion on how a job site database looks like. i mean how is the structure and how the jobs are stored in the database. Can any one help me on this.

shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
The database will depend on the requirement on what are the data you would like to store.
Tragiccomic's Avatar, Join Date: Mar 2007
Newbie Member
The database will contain the necessary information about the persons detail , like the resume. My problem is to get an idea of how the database of a jobsite should be. Since i would be taking in data about a person on a form , so it will be difficult for me to design the database and how many tables should it have.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
But if you are unable to design the database of the job site go one step at a time. Get the personal details of the user first then have the resume table.

As a very distant view I can suggest you to have the following tables
UserDetails
Resume
JobApplications
JobDetails
.
.
.
Tragiccomic's Avatar, Join Date: Mar 2007
Newbie Member
I am planning on having a user registration and login page too in this jobsite. So i think i will also need another table to store the username and password. but how can i build a database to related them with the resume which the posted. im confused .........
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Based on the username / userid you have in the user table link them to the column in the resume table which also has username / userid