Re: Relational and multivalue databases

From: Dave Rolsky <autarch_at_urth.org>
Date: Sun, 22 Feb 2004 00:50:18 -0600
Message-ID: <Pine.LNX.4.58.0402220049490.29913@urth.org>

On Thu, 19 Feb 2004, Dawn M. Wolthuis wrote:

> How do you decide whether info is a sub-table of an existing table or should
> go in its own table? If the information is functionally dependent. My
> phone numbers are information that one might think of as being in the
> relationship between me and the telecom industry. But my phone numbers have
> no meaning apart from me -- sure they are phone numbers that exist in the
> world, but the point of capturing the data is to capture information about a
> person. So, don't stick them in some other function (aka file) -- put them
> with the person, even if there are more than one of them.

So you've never encountered two people who share the same phone number?

-dave

/*=======================

House Absolute Consulting
www.houseabsolute.com

=======================*/

Received on Sun Feb 22 2004 - 00:50:18 CST