Unanswered: relationships instructor teach many subjects.
I have two tables.
my situation is. an instructor can teach more than one
subject in any department but he belongs to one
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.