Re: Ideas for World Hierarchy Example
From: Neo <neo55592_at_hotmail.com>
Date: 12 Jan 2007 15:38:02 -0800
Message-ID: <1168645081.722102.294100_at_q2g2000cwa.googlegroups.com>
Date: 12 Jan 2007 15:38:02 -0800
Message-ID: <1168645081.722102.294100_at_q2g2000cwa.googlegroups.com>
> You will notice I snipped your model ...
Again? OK, but keep it above the belt line. Don wanna be !!!
> T_Country (country_id, country_name)
> T_City (city_id, city_name, country_id)
> T_Capital (city_id, capital_types)
>
> Does the above model work?
For me personally, I think the above would work great.
But now I am trying to make the db understand on its own, so the above looks like the below to it:
T1 (id1, f1) T2 (id2, f1, id1) T3 (id2, f2)
Here the db can say type T1 things have attribute f1. And type T2/T3 things have attributes f1, f2 with multiple values and to f3(id1). It doesn't know enough. Am I expecting too much? Received on Sat Jan 13 2007 - 00:38:02 CET