O
oftenconfused
I know how to construct a many-to-many relationship, I'm just not sure when
one is required. Sometimes it's obvious -- for example, teachers can have
many students, and students can have many teachers. But, I find that in many
cases it's not so obvious (at least for me!) -- for examples, a company can
operate in many cities, a city can have many companies that do business
there. Do I need a many-to-many relationship in the later example? I'm
hoping someone can give me a common sense rule for determining when a
many-to-many relationship is required (preferably, with several examples).
Thanks!
Andre
one is required. Sometimes it's obvious -- for example, teachers can have
many students, and students can have many teachers. But, I find that in many
cases it's not so obvious (at least for me!) -- for examples, a company can
operate in many cities, a city can have many companies that do business
there. Do I need a many-to-many relationship in the later example? I'm
hoping someone can give me a common sense rule for determining when a
many-to-many relationship is required (preferably, with several examples).
Thanks!
Andre