Re: another simple data modelling question

From: JRStern <>
Date: Fri, 18 May 2001 01:09:36 GMT
Message-ID: <>

On Thu, 17 May 2001 20:50:12 GMT, crappy <> 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

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 Fri May 18 2001 - 03:09:36 CEST

Original text of this message