need help for employee skills database design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am in the process of desiging a database that contains employee skills
I have resolved most of the problems, except for one that allows for one
employee to have multiple skills and keep a table reflecting that.

My previous experience with databases was not with relational databases only
flat
so this is my actual first attempt at this, could someone direct me to a
sample
database that I could download, and or give me some tips on how to link my
tables
and what to put in them ie fields and etc, thanks bunches..
I understand this is kinda vague , it's the best I can do
 
Consider beginning with 3 tables:
tblEmployees
================
EmployeeID
.....

tblSkills
================
SkillID
SkillTitle

tblEmployeeSkills
===============
EmpSkillID
EmployeeID
SkillID
SkillLevel
 
Back
Top