Re: Ideas for World Hierarchy Example

> 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 Fri Jan 12 2007 - 17:38:02 CST