4 Replies Latest reply: Jan 7, 2015 9:42 AM by Nick Hoff RSS

    Database logical structure

    Ruud Cruchten

      Hi all,

       

      I'm facing a frustrating problem at the moment, I'm developing a skill management tool but I cant seem to get the database structure correct (works fine in Access). The problem is this: An employee has an employeeID, and a JobID. Linked to a certain job there are some skills, so each skill has a Job ID as well, the problem causer is the fact that every employee has their individual skills graded which causes a loop:

       

      Database with loops.jpg

       

      I thought that creating a duplicate table of jobs did the trick but now I face the problem that the jobs that are mentioned in the employee table aren't logically related to the skills anymore:

       

      Database without loops.jpg

       

      Anyone has any suggestions to solve this problem?

       

      Thanks in advance!