Page 1 of 1

Help with Table Structure

Posted: Tue Mar 24, 2009 7:24 am
by nishmgopal
Hi Guys

I have been having some serious trouble getting the information I want, and Have taken the advise to restructure my tables. I have attached the Old Structure and the new one.

I was just after some constructive advise on whether the new one is better and if it will help me get the info i want, which is:

I want to display a table with the following colums

Required Skill (comes from ID_Table) Weight (Comes from ID_Table) Score (Comes from Person_Skill)

does this make sense?

Thanks in advance

Re: Help with Table Structure

Posted: Tue Mar 24, 2009 11:37 am
by wellhole
You'll want to add Job_ID to Person_Skill as well because (Job_ID, Skill_Name) are the unique keys for ID_Table. I also recommend that you change your table names to upper case and your members to lowercase.

This may be a preference issue, but I wouldn't use the same member names for every table, such as ID. When joining, it'll be a pain in the ass to reference them. I suggest psid for Person_Skill, piid for Person_ID, jiid for Job_ID, and itid for ID_Table.