Re: another simple data modelling question

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