Re: A Normalization Question

From: VHarris001 <vharris001_at_aol.com>
Date: 09 Jul 2004 13:38:49 GMT
Message-ID: <20040709093849.29796.00001162@mb-m18.aol.com>

>
>> Why isn't each "pet" considered a unique thing rather than a quantity?
>
>Consider other kind of quantities instead.
>How about money, weights and lengths ?
>

Shouldn't the database program offer the flexibility to handle all data instances? That is, it can be tracked if one person has pets (Y/N), how many (QTY), how many of each (TYPE/QTY), individual pets, with names, breeds, etc.

But to offer this flexibility in a typically normalized database requires too many tables. Isn't the better alternative to contain all the data in one table and use multiple pointers?

V Harris Received on Fri Jul 09 2004 - 08:38:49 CDT