Re: another simple data modelling question

thanks for the replies.

i'm not sure if i understand .. wouldn't adding personality_id to the person table denormalize it, since it would then have to inherit personality_id from characteristic_personality?

also, in case i wasn't clear in my first post, i don't want to have a person to have *all* the characteristics that are allowed for his personality_type, just some of them. so characteristic_personality lists which characteristics are 'allowed' for which types, and characteristic_person lists which persons have which characteristics.

the trigger would work, but i wanted to see if there was a way to do it thru RI .

thanks.

In article <3B04B8FE.59761A1_at_racon-linz.at>, Heinz Huber says...
>
>From what I read, I understand that a person is only allowed to have the
>characteristics that are specified for it's personality.
>If this assumption is true, I wouldn't relate person and characteristic (table
>person_characeristic above). I would relate person directly to
>characteristic_personality and ensure that the personality_ids match
>(automaticly, if you promote personality_id to a part of the key in person).
>This way you can also set up RI.
>
>hth,
>Heinz
Received on Fri May 18 2001 - 18:05:11 CEST