I'm considering adding models for storing street addresses, and I'm curious what the most efficient way to store them is? Should there be separate City, State, Country models, or just one StreetAddress model with city, state, country columns that repeat? I'd like to balance both query performance and storage space efficiency if possible.
#activerecord #normalization #schema #database