Database relationship

alrodean fransmab

13y1.6k.NET

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sunny Sharma13y ago
Accepted answer
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 !!
alrodean fransmab13y ago
Thanks i will go through them now
alrodean fransmab13y ago
hi Thanks for the reply.. im not so good with databases so you lost me by normalization
Sunny Sharma13y ago
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 :)