I'm setting up a table and I've been scratching my head along with Google on how to structure this. Maybe someone here can lend a thought.
What I'm doing is setting up a skills matrix. It contains a list of employees and their respective skills. I can handle the UI development once I decided on what my tables are going to look like. I don't want to create redundancy so I'm looking for 2NF or 3NF if possible. Here's my skills table (mock up):
Skill_ID | SkillName 1 | A 2 | B 3 | C 4 | D
Employee table (mock up):
Emp_ID | Skills 1 2 3 4 5
So, that's one way I've thought of doing it, but how do I keep it "neat" when it comes time to give an employee "skill id's"? Another way I thought, which seems to work but it's definitely not 2NF is:
Emp_ID | Skill 1 | 1 1 | 2 1 | 3 2 | 1 2 | 2 2 | 3
that doesn't seem very efficient to me, but it would work I guess. I don't know. Any thoughts?