hi

one simple question please. I have three tables.
Code:
 
**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:

Code:
  **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)
thanks