MartyConnelly
martyconnelly at shaw.ca
Fri Aug 19 00:18:43 CDT 2005
If you are doing this for mailing look up IPU lists otherwise I would use UN membership for political reasons There are still small UN protectorships and nations and areas not recognized by the UN, The ISO list is about 10 years behind the times. Vienna was divided into US, British, French, and Soviet occupation zones 194555. Berlin was similar forgot the time frame but was considered West German after western Allied Powers occupation zones dissolved. Macau was Dutch colony till 99 as was Hong Kong British colony now Chinese SAR Special Administrative Region. as is Tibet but Chinese piked that in 50's. Hong Kongers were once allowed a British Overseas passport that did not give residence right in Britain. Singapore was part of Malaya British Colony, Three years after Malaya independance majority 75% Chinese in Singapore seperated 1963. I haven't used the term City-State since the Hanseatic League dissolved. Then in Canada you have first nations. A rose is a rose. Oh yes Texas can still secede or split into 4 states within the union. The Turks and Caicos want to become Canada's 11 province. The list is endless. Try nailing Jello to a wall it would be more fruitful. Even the CIA factbook list is missing Nations or wannabes look up Palestine, Chechyna. Arthur Fuller wrote: >Fortunately, there is a DB design question herein, else I'd have to post it >on the OT list, which is way too noisy for me LOL. > >I was under the impression that Singapore was a city-state, but I googled a >few things and discovered that it is considered a nation. Further, said URL >(http://www.cia.gov/cia/publications/factbook/geos/sn.html) contains a very >interesting set of columns, but I will confine this question to the set >titled "Government", which includes: > >Country Name: > Long form: Republic of Singapore > Short form: Singapore >Government Type: >Capital: Singapore >Administrative Divisions: >Independence: >National Holiday: >Constitution: >Legal System: >Suffrage: >Executive Branch: >Judicial Branch: >Legislative Branch: >Political Parties and Leaders: >Political Pressure Groups and Leaders: >International Organization / Participation: >Diplomatic Representation from the U.S.: >Flag Description: > >(Fill in the blanks by visiting the URL above.) > >My questions are: > >1. Is Singapore a city, a nation-state or a nation? >2. Are these terms obsolete? >3. Was Singapore declared a nation simply so it could fit conveniently into >the database? >4. Are there any other cities to which we might ascribe the descriptor >"city-state"? (Or do we fold all such potential candidates into "nations" as >this database does with Singapore?) >5. Are there any parts of the nation of Singapore which are not parts of the >city Singapore? >6. Prior to 1999, how was Hong Kong classified? (And currently, how is Macao >classified?) >7. Prior to reunification, what was the status of Berlin? >8. In post WWII, what was Vienna (c.f. "The Third Man", directed by Carol >Reed and starring Orson Welles and Joseph Cotton)? A city-state? A city >controlled by four armies? A remnant of pre-war Austrian glory? > >Opinions and references most welcome! And just to ensure that this stays in >the DB realm, until now I have been using the ISO list of nations. Perhaps I >should expand my list of columns to include all these other attributes? > >TIA, >Arthur > >_______________________________________________ >dba-Tech mailing list >dba-Tech at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-tech >Website: http://www.databaseadvisors.com > > > > -- Marty Connelly Victoria, B.C. Canada