Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013
    Posts
    3

    Unanswered: relationships instructor teach many subjects.

    I have two tables.
    tbldepartments.
    tblinstructors.

    my situation is. an instructor can teach more than one
    subject in any department but he belongs to one
    department.
    example: instructor A belongs to department of physics, but
    he can also teach mathematics and chemistry.

    I think this is a many to many relationship, it has appeared
    to be a challenge to tackle. please advise.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14

Posting Permissions

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