OpenEuphoria

Re: [OT]Where's everyone from? Contest

• Posted by "Juergen Luethje" <j.lue at gmx.de> Aug 07, 2004
• 406 views

Derek Parnell wrote:

> Lewis Townsend wrote:
>>
>> I like this idea.
>>
>> The database should include: "*" indicates index key fields
>>
>> [city table]
>> *Name
>
> This will not be sufficient because it is possible to have two or more
> cities with the same name. I live in Melbourne, Victoria, Australia, not
> Melbourne, Florida, USA.

Ahhh... Now I know, what "VIC" means, when my 'Globe' program says
"Melbourne VIC".

> Instead, just give each city a unique id value just like you'd give people.
> Maybe the Location value could be used, so long as it wouldn't be possible
> to move a city to a new location.

And of course the id value then should be used to refer to that city.
Also, it is not necessary (and not recommendable, IMHO) to repeat
the 'State/Province' and 'Country' fields in [Person table].

>> Country
>> State/Province
>> Location(lat,long)
>>
>> [Person table]
>> *ID number
>> Last Name
>> First Name
>
> Instead of Last/First name, use Family/Given name as these cross cultures
> a bit better.  Not all cultures place the Family name last.
>
>> City
>> State/Province
>> Country
>> Notes(euphoria relevant info)
>>
>> This way only the city records would contain coordinants.
>> and the people records would contain city, state, and country.
>> This seems like a good way to simplify the globe so there won't
>> be multiple dots in one spot.

Additionally, I actually would like to have some time zone information.

So from my point of view, the summary up to now looks something like
this:

The database should include: "*" indicates index key fields
                             "#" indicates connection to another table

[Time Zone Table]
*#ID number
Name
Offset from UTC(+- hours)
Dailight Saving Time(offset, +- hours)
Begin of Dailight Saving Time
End of Dailight Saving Time

[City Table]
*#Location(lat,long)
#[Time Zone Table]ID number
Name
Country
State/Province

[Person Table]
*ID number
#[city table]Location(lat,long)
Family Name
Given Name
Notes(euphoria relevant info)

Regards,
   Juergen