I am working on creating my first data model and ended up with a simple but complex question.
I can post my narrative if necessary, but for this question I feel it's overkill.
I have Vendors, Drivers, Post Offices, Trips, Drug Screen Clinics, etc all have states and cities they are located in. Should I make a single Locations table that lists the City and States? I will need to search through the data by state or city at some point.