Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008
    Posts
    4

    Unanswered: Relationships between tables

    Hi Everyone,

    I was hoping someone could shed some light on my problem.
    I am creating a job recruitment system for my final year project, left it a bit late, got the basics done but my relationships are stil not 100% and i am worried i may have started this completly wrong. Below are the relations

    RECRUITER TABLE
    RecruiterID (PRI KEY)
    RecruiterName
    RecruiterSurname
    Company
    Address
    PostCode
    Telephone
    Fax
    E-mail
    Pwd

    SEEKER TABLE
    SeekerID (PRI KEY)
    SeekerName
    SeekerSurname
    DateofBirth
    Address
    PostCode
    Telephone
    Mobile
    Pwd

    JOB TABLE
    JobID (PRI KEY)
    RecruiterID*
    SeekerID*
    Description
    Pay
    ContractType
    Hours

    APPLICATION TABLE
    ApplicationID (PRI KEY)
    JobID*
    RecruiterID*
    SeekerID*
    Qualifications
    PreviousEmployer
    Reference

    Please put this link in your broswer to see my relations in ACCESS.
    http://img132.imageshack.us/img132/8...lationswp4.jpg


    The problem i am having is that the jobseeker cannot view the job that was input from the application. Any ideas on how this thing can be made better?. I would be ever so greatfull.

    Thanks

    Mazkaf

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by mazkaf
    JOB TABLE
    JobID (PRI KEY)
    RecruiterID*
    SeekerID*
    Description
    Pay
    ContractType
    Hours
    Can one job only have one Seeker?

    Describe your entity relationships in the following form:

    One job can have many applicants
    One applicant can apply for many jobs
    ...etc
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •