Design for an instructors database

  • Thread starter Thread starter jancoffin
  • Start date Start date
J

jancoffin

Am working on a database to track instructors and what
they are able to teach. It will include computer software
as well as safety and other types of courses.

What would your advice be:

1. A table for Instructors

2. A table for skills (instructors could know many
applications and levels.)

3. A third table to "relate" them.



OR

Just fields within ONE Instructor table.. there would be
YES/NO fields for each application and level.. ex: word
2000 intro, word 2000 intermediate, word 2000advanced. Etc.

The goal is to be able to run a query that would list
instructors who can teach a given application version and
level.

Many thanks for your thoughts!
 
Your first method is by far the best. Any method that would require adding
fields and controls as new skills are needed would be a poor system and very
difficult to maintain and use.
 
Back
Top