Re: A Normalization Question

• Post for FREE via your newsreader at post.usenet.com ****

"VHarris001" <vharris001_at_aol.com> wrote in message news:20040709093849.29796.00001162_at_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?

You avoided the question.
How do you model money, weight and length values ?

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=