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

Sunny Sharma · 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 fransmab · Answer

Thanks i will go through them now

alrodean fransmab · Answer

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

Sunny Sharma · Answer

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 :)