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$>

> > 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 - 11:51:05 CET

Original text of this message