Re: Multiple parent design

From: T <>
Date: Fri, 16 Apr 2004 14:55:31 GMT
Message-ID: <DtSfc.12774$>

Bleh. Couple of reasons for not liking this solution:

  1. It is denormalized.
  2. As such, it does not account for the addition of other parent entities.


"Laconic2" <> wrote in message
> Create two columns in the phone table, Person_id and Company_id. Enforce
> referential integrity on each one separately. Allow each one to be NULL.
> If necessary, enforce a constraint that either Person_id or Company_id
> be null.
Received on Fri Apr 16 2004 - 16:55:31 CEST

Original text of this message