Welcome Guest, Not a member yet? Register   Sign In
MySQL Design Question
#5

[eluser]insub2[/eluser]
[quote author="jedd" date="1261171995"]Can you ever review an entire business - ie. one that has multiple locations, and you want to review them all as a single entity?[/quote]
You'd review and entire business by not specifying any locations (so yes to #3).


Quote:Can you ever review a subset of an entire business. ie. one that has multiple locations, and you want to review >1 & <n of those locations?
The Location IDs will be in an arbitrary order because of how the Airport data is imported -- Locatoins 50 through 55 may not refer to same business. The user will essentially check off the locations they are reviewing.


Quote:Can you ever review a business without reference to any of the locations it has?
Yes.


Quote:Do any businesses have no location (eg. an Internet-only business)?
As of right now, no. The site does not offer reviews on things without Locations. But theretically, I suppose it should be possible because the only required relationship is between busines and review.


Messages In This Thread
MySQL Design Question - by El Forum - 12-18-2009, 04:43 AM
MySQL Design Question - by El Forum - 12-18-2009, 05:15 AM
MySQL Design Question - by El Forum - 12-18-2009, 09:28 AM
MySQL Design Question - by El Forum - 12-18-2009, 09:33 AM
MySQL Design Question - by El Forum - 12-18-2009, 10:02 AM
MySQL Design Question - by El Forum - 12-18-2009, 03:48 PM
MySQL Design Question - by El Forum - 12-18-2009, 04:25 PM
MySQL Design Question - by El Forum - 12-18-2009, 04:31 PM
MySQL Design Question - by El Forum - 12-18-2009, 04:35 PM
MySQL Design Question - by El Forum - 12-18-2009, 04:49 PM
MySQL Design Question - by El Forum - 12-18-2009, 05:05 PM
MySQL Design Question - by El Forum - 12-18-2009, 05:08 PM
MySQL Design Question - by El Forum - 12-18-2009, 05:12 PM
MySQL Design Question - by El Forum - 12-18-2009, 05:23 PM



Theme © iAndrew 2016 - Forum software by © MyBB