one simple question please. I have three tables.
GROUP id area 1 Multimedia 4 Education Employment id foreign key(GROUP) job 1 1 designer 2 4 professor 3 1 copy and now suppose that i have this SpecificProperties id foreign key (Employment) properties 1 1 type of contract 2 1 number of jobs 3 2 duration contract (no type of contract) 4 2 number of jobs
the designer and the professor in this case have the property number of jobs. So basically the question is, i need repeat the number of jobs for each profession? there is any way to avoid? or i can have to number of jobs 8 foreign keys to 8 different jobs for example ? one for designer, other for professor, other for copy, and so on? in this way the first number of jobs have in the foreign key 1 || 2 || 3
something like this:
**SpecificProperties** id foreign key (Employment) properties 1 1 type of contract 2 1||2||3||4 number of jobs 3 2 duration contract (no type of contract)
But this also give me problems because i need to store some information in the type of contract, duration, etc
so the correct must be this?
SpecificProperties id type of contract number of jobs duration
i need some help. seriously, i can't find a solution for this in last two days.