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: Multiple parent design

Re: Multiple parent design

From: T <anyone_at_anywhere.com>
Date: Fri, 16 Apr 2004 14:55:31 GMT
Message-ID: <DtSfc.12774$k05.10723@newsread2.news.pas.earthlink.net>


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.

Tom

"Laconic2" <laconic2_at_comcast.net> wrote in message news:64GdnYurVfsYVOLdRVn-sQ_at_comcast.com...
> 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
must
> be null.
>
>
Received on Fri Apr 16 2004 - 09:55:31 CDT

Original text of this message

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