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

    Database logical structure

      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!