|
Posted by Doug_McMahon on 08/15/07 17:53
BTW my earlier mistake shows the danger of making assumptions. For
example the users of the system may have had in mind a relationship
where a theater is listed by all zip codes for which it's considered
"close enough", implying a many-to-many. Or, it could be that a zip
code is assigned a lat/long coordinate or bounding-box lat/long
coordinates, as are all theaters, and the query is supposed to do some
sort of spatial operation, implying no direct relationship at all
between theaters and zip codes.
Navigation:
[Reply to this message]
|