MySQL Design Question

[eluser]insub2[/eluser]
[quote author="jedd" date="1261156517"]
Just to confuse matters .. a business may have multiple premises. A review may apply to one branch of a business, specific to a location. Your design may need to accommodate this.[/quote]

Yep, confused!

The way the site works is thtat one can only write a review for one business at a time. And you don't have to review all of that business' locations (branches). BUT each location can have multiple businesses.

To expand on the example:

United Airlines will fly out of O'Hare, Atlanta, LAX, etc.
(Business to multiple locations)

If someone wanted to review a flight they took from O'Hare to LAX, I can't just do Review->Business (United) because it wouldn't have the Locations (Airports) specified. And I can't just to do Review->Locations because O'Hare and LAX have multiple Airlines flying out of them (thus, no business would be specified).

So, I need to specify Review to Business AND Review to Locations. Hence my trouble.