I have to create a database in Access and I desperately need some help.
One of the things I need the database to store is general information about technicians, (things like name address, telephone etc) that's quite easy to do.
However I also need to store the following information about technicians:
Qualification level- assume that there are 5 levels of training technicians receive and a corresponding qualification for each. So a technician does a training course and then at a later date does an exam which they either pass or fail. In terms of storing data, the technician can take the course and the exam (or the exam without the course) as many times as they like. Level 1 is the basic training. Also, there are new models course which they have to take regularly. However, there are no exams for it.
To store all this I was thinking about creating 3 tables.
1st Table: Qualification Exam
TechnicianID - (foreign key from technician table)
New Models Course table
TechnicianID foreign key
In my ERD, I have only one qualification entity and that creates problems when I have to write the attributes for it. Should the relationship between technician and qualificiation be many to many or 1 to many?
Is there a better/more efficient way of doing this? Any suggestions?
I don't really know how to explain myself clearly so I'm attaching the exact question we received.
Last edited by AccessDatabase; 04-08-11 at 12:20.