But seriously ... Is there an implication here for schema design, given changing demographics and political upheaval?
Perhaps geographical records should be rooted to latitude and longitude; and these are then many-to-one'd to a 'virtual country' with no real-world political affiliation of its own; which then one-to-many's to 'actual countries' which can begin or cease to exist at any time. The 'actual country' records would include all metrics such as 'date of independence' and border data, etc. Thus my relations left behind in central Europe could be traced as members of the Ottoman Empire, the Kingdom of Romania, Transylvania, Greater Romania, Liebensraum (NOT a good time to be there), Republica Populara Romana (glad to be in the USA) and Rumania again with the tweak of one field. I'm just saying. bruce chitiea safesectors inc. > -------- Original Message -------- > Subject: [RBASE-L] - OT - geography lesson > From: [email protected] > Date: Thu, February 17, 2011 8:00 am > To: [email protected] (RBASE-L Mailing List) > > > I have what I thought was a pretty up to date Countries table from one of > my clients. I know that countries are changing all the time... but still I'm > confused. > > I don't see anything for Belgium. Isn't that a country still? > > And what's up with Germany? Is there just one Germany now? I have a > couple addresses that say "West Germany", and I'm wondering if that should > now be > just "Germany". > > Thanks! > > Karen
