I want to make a database that stores countries, their respective states, and cities. I am confused how to normalize these. Can anyone help?
Table 1 Countries (id pk, name , code) Table 2 State (id pk, name, country_id fk, code) table 3 Cities (id pk, name, state_id fk, pin_code)
I want to store hotels along with their address(es):
table 4 address (id pk, street_address, city_id fk, state_id fk, country_id fk) table 4 Hotel (id pk, name, address_id)
Are there any changes for future proofing I should make, or any other mistakes I've made?