Re: Relational and multivalue databases

"Marshall Spight" <mspight_at_dnai.com> wrote in message news:_1c_b.369115$I06.3888698_at_attbi_s01...
> "Dawn M. Wolthuis" <dwolt_at_tincat-group.com> wrote in message
news:c1agf7$v53$1_at_news.netins.net...
> >
> > Sure, but what do you want to do, Dave -- get a random identifier for
each
> > phone number and then since people have more than one have a link tabke
that
> > links people with each of the keys to their phone numbers? I guess that
> > might make sense to someone in the RDBMS world, but step back a minute
and
> > look that -- the not-terribly-technical-term "silly" comes to my mind.
>
> That argument may carry some weight when the data type involved, a phone
> number, is approximately the same size as a foreign key.

As you point out, the suggestion to have a surrogate for a simple, familiar, stable candidate key is simply fatuous. But what can one expect from someone like Dawn? Received on Mon Feb 23 2004 - 03:41:38 CET