How would a relational database look for this senario?
(db of shoppers) LOTS OF SHOPPERS inside
(db of stores) LOTS OF STORES inside
(db of cities) LOTS OF CITIES inside
(db of states) LOTS OF STATES…
And when a shopper’s profile is shown, there is a chain of information
as to the store the shopper is affiliated with, in which city, and in
which state…
For sure it’s an ‘acts_as_tree’, unless there’s a better way.
Would this use the Acts_as_HABTM? will it use polymorphizm? through?
etc…
I appriciate the help.