sql jobsite database sample

Discussion in 'Database' started by Tragiccomic, Mar 14, 2007.

  1. Tragiccomic

    Tragiccomic New Member

    Joined:
    Mar 14, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    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.

    :) :)
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    The database will depend on the requirement on what are the data you would like to store.
     
  3. Tragiccomic

    Tragiccomic New Member

    Joined:
    Mar 14, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    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.
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    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
    .
    .
    .
     
  5. Tragiccomic

    Tragiccomic New Member

    Joined:
    Mar 14, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    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 .........
     
  6. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    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
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice