| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: unique primary key shared between multiple tables.
> > 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
![]() |
![]() |