1. Re: [OT]Where's everyone from? Contest
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
