Re: 2 people with same address - sometimes - standard data model?y

> >You can use the phone number as a unique household primary key -- that's
> >what mail-order houses do. Of course, this will break down for business
> >records...
> >
>
> So what about houses with more than one phone, multiple people with the
> same name, with a guest house across the county line in a different area
> code, divorced parents who sometimes live together and each use different
> names for personal and business purposes and...

Normally, a NON-intelligent key is used. Just a sequence counter. The use of "intelligent" primary keys has long been regarded as a colossal mistake. Received on Mon Jan 30 1995 - 19:41:27 CET