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 15:00:22 GMT
Message-ID: <aySfc.12778$k05.9161@newsread2.news.pas.earthlink.net>


The downside to this approach is that extensibility is difficult. In other words, every time I need to add a parent entity that can have a phone I would need to add two tables and adjust any database writes to save to two tables. This is similar to the solution whereby I create a "Parents" table that contains a combined list of Company id's and Person id's.

Thomas

<snip>

> Create two tables Companyphone and Personphone. Add check constraint
> "phone not in {the other table}". Create obvious foreign keys. Create
> view Allphone as Companyphone UNION Personphone.
Received on Fri Apr 16 2004 - 10:00:22 CDT

Original text of this message

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