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:
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:
You are correct. Instead of IndividualS apply map to Skills. Typically when you have a table in your data model that has ID, Description/Value, the general rule is to apply map to the table it relates to. Instead of a snow flake schema you'll see more performance out of a star schema. Your final data model should only be three tables, IndvidualS, Skills, and Employees
Another rule is when you have two tables with the same primary key, they should be joined.