Country organisation

[endri81]

Hi
Which is the best way to organize country data about municipalities,cities,villages and communes if to one city refers more than one village and so on...

 

[the_net_2.0]

In the US, the structure is the order that you've already listed. Generally, this is right in line with Access database theory, so what you'd have as a table setup would generally be this:

tMunicipality

• mId (PK)
• mName

tCity

• cId (PK)
• cName
• cMuni (FK on MId from tMunicipality)

tVillage

• vId (PK)
• vName
• vCity (FK of cId in tCity)

tCummune

• cId (PK)
• cName
• cVillage (FK from vId in tVillage)

Referential Integrity should also be enforced in this situation. It would make no sense without it.

HTH