Design for an instructors database

[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!

 

[Duane Hookom]

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.