How to split a table into several?

Question

MySQL

Good day, there is a `cities` table that stores (id_ Countries, Region, City). How best to split it into separate tables (City, Region) so that cities do not lose touch with regions and regions with countries.
Is it possible to do this with this table in principle?

Answer 1

countries (id, name)
regions (id, country_id, name)
cities (id, country_id, region_id, name)