Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: another simple data modelling question

Re: another simple data modelling question

From: crappy <nospam_at_newsranger.com>
Date: Fri, 18 May 2001 16:05:11 GMT
Message-ID: <XKbN6.7752$6j3.644649@www.newsranger.com>

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 - 11:05:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US