Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011
    Posts
    10

    Question Unanswered: Relationships with entities and tables

    Hi guys,

    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
    QualExamID#
    TechnicianID - (foreign key from technician table)
    Level
    ExamDate
    Result

    2nd table: Qualification Course
    QualificationCourseID#
    TechnicianID foreign key
    CourseDate
    Level
    QualificationExamID

    New Models Course table
    NewModelsID#
    TechnicianID foreign key
    CourseCode
    Date

    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?

    Thanks

    Fred

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Please do not cross post the same question on multiple forums.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •