I need to implement the hierarchy for Country - City - District where 1 to many relations exist between them. Apparently, the business key for city is its name with the country while the business key for district should be its name with either the city reference or city + country.
It was suggested that each of the above mentioned entities should be separate Hubs
with the name as business key. However, I disagree because there are many cities with the same name. So, if I created a hub
for city with the name as business key, one record might represent multiple cities.
How this can be implemented?