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: JRStern <JRStern_at_gte.net>
Date: Fri, 18 May 2001 01:09:36 GMT
Message-ID: <3b0476e9.32763421@news.gte.net>

On Thu, 17 May 2001 20:50:12 GMT, crappy <nospam_at_newsranger.com> wrote:
>now my problem is this: how do you ensure that person/characteristic pairs are
>valid with respect to the characteristic/personality pairs, *as well as* the
>implied personality of each person (via the child-parent relationship between
>person and personality)?
>
>in other words, with the given setup, it is possible to give a person a
>characteristic (in person_characteristic) that isn't 'allowed' for that person's
>personality.

Apparently you have some such constraints, of characteristics allowed for a personality. Put them in a fourth table, put a trigger on the person_characteristic table to check it.

J. Received on Thu May 17 2001 - 20:09:36 CDT

Original text of this message

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