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: unique primary key shared between multiple tables.

Re: unique primary key shared between multiple tables.

From: programmer <BROWNHIK_at_Syntegra.Bt.Co.Uk>
Date: Mon, 17 Mar 2003 10:51:05 -0000
Message-ID: <b549nv$a4p$1@pheidippides.axion.bt.co.uk>


> > Put all private owners and business owners in the same table,
> distinguished
> > by a flag.
>
> From the original description of the problem, what makes you assume
> PrivateOwner and BusinessOwner share any similar attributes other than
> ownerNo?
>

Not very likely that they don't, is it?

> What happens later when the business needs to introduce a
> PublicSectorOwner?
>

Replace the flag with a character variable if there is any possibility that this may be needed in the future. Received on Mon Mar 17 2003 - 04:51:05 CST

Original text of this message

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