Hi, For Malta, the States are not technically correct. Villages and Towns have been used as States. There are two Islands:
Malta and Gozo. Country is Malta, but Gozo is a Region - also important as there are a few town names in each island which are identical. e.g. Rabat, Malta and Rabat Gozo, Mgarr Malta, Mgarr Gozo, Zebbug, Malta, Zebbug, Gozo
So, either the States need to be reduced simply to:
Malta
Gozo
Or
The Gozo town names are suffixed as follows:
Gharb, Gozo
San Lawrenz, Gozo
Ghasri, Gozo
Zebbug, Gozo
Marsalforn, Gozo
Victoria, Gozo (also known as Rabat, Gozo)
Fontana, Gozo
Xaghra, Gozo
Nadur, Gozo
Qala, Gozo
Ghajnsielem, Gozo
Mgarr, Gozo
Sannat, Gozo
Munxar,Gozo
Xlendi, Gozo
I think that's all the entries. The ones in bold are the biggest issue as they are towns in both islands.
However, surely it would be simpler to have 3 tables: Countries, States, Cities, linked with country code and country-state codes respectively? then the states for Malta can simply be: Malta and Gozo
Also, some names with incorrect spelling:
Gaxaq - should be Ghaxaq
Xagra - should be Xaghra
Melliea - should be Mellieha
Xgajra - should be Xghajra
These would need to be changed in the product. Thoughts?