Is data integrity possible without normalization?
- by shuniar
I am working on an application that requires the storage of location information such as city, state, zip code, latitude, and longitude. I would like to ensure:
Location data is accurate
Detroit, CA
Detroit IS NOT in California
Detroit, MI
Detroit IS in Michigan
Cities and states are spelled correctly
California not Calefornia
Detroit not…