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_at_pheidippides.axion.bt.co.uk>
Date: Mon, 17 Mar 2003 10:51:05 -0000
Message-ID: <b549nv$a4p$1_at_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 - 11:51:05 CET