Database relationship

Question

Hello,

I'm making a website "Recruitment agency" as a project and i have an issue. I want to use 3 tables

1. Applicants
2.New Jobs
3.Companies

Now i did all this good and well but i cant seem to relate the tables.

eg. i have a reference number for the job so this this should relate to the company? Now the way i'm thinking is

One company can have many job offers "New Jobs".
New Jobs can have many Applicants.
Applicants can have many new Jobs.
Company can have many Applicants.

This is so confusing i don't know how to do this.

When i use asp to add an "New Job" it gives me an error saying "Can't add because table is related to another account"

Help Please

Answer 1

Not a problem. You first define all your Entities, their attributes and we can help you with that.

Also, Here are some good links to get yourself started with Database Normalization:

http://holowczak.com/database-normalization/

http://www.phlonx.com/resources/nf3/

http://databases.about.com/od/specificproducts/a/normalization.htm

Suggest you to go through the links above and you should be fine.

Cheers !!

Answer 2

Thanks i will go through them now

Answer 3

hi Thanks for the reply.. im not so good with databases so you lost me by normalization

Answer 4

Try to detail the every required entity in full, do a normalization and you'll be fine. Can't help you right away as you don't have a defined What To Do. Hope you got the point :)