Table structure?

[Ruslan Zasukhin]

On 4/28/06 11:31 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

> 
> This is an "Atlas" database (none graphical, just data) so I have following,
> in a relational schema:
> 
> Table1 (A place in the world)
 Place|
 LatDeg|
 LatMin|
 LatSec|
 LatCompass|
 LongDeg|
 LogMin|
 LongSec|
 LongCompass|
 Country|
 TimeZoneID

1) where is KEY field in this table ?
 
> Table2 (Timezones in the world)
 DateTimeOfChange|
 ChangeVal|
 Ptr_Country|           << this is Foreign Key?
                             It point to T1.Country field?
   
 Ptr_TimeZoneID         << this is another Foreign Key ?
                             it point to TimeZoneID ?

   so this is 3 Foreign Keys?
    or single Foreing key

Can you give first of all CONCEPTUAL diagram, i.e. Which Objects you have
and which links between them exists?

Something like:
    Person  has  Phones
       M           M

 
> I know how to set this up in a "traditional" way, but I wanted to use unique
> features of Valentina, preferably BinaryLinks as they seem very clean and
> simple to me, and probably the fastest. I am not sure though if BinaryLinks
> are usable here, but maybe ObjectPtr?
> 
> How it works in practice in program is, a place are picked, either from
> returned SearchCollection or from List. Next, based on country AND ZoneID
> (most countries have just 1 but some have over 300) a timezone value are
> returned with passed DateTime as criteria. Quite simple yes in Relational,
> but I like to learn and use something new and is still unfamilar with
> Valentina. My way of thinking though is if I learn and understand something
> difficult, then I understand everything, sort of...

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]