Re: Help with Database design

I kind of agree Kelly's point. You have to find out whether there are duplicate records for the same customer. If they have probably this was done as part of normalization. You got to ask urself these question (Kelly's question) before u decide to denormalize them.

-raju

> How many email addresses can a customer have?
> How many phone numbers can a customer have?
> How many mailing addresses can a customer have?
>
> I bet the answer to each question is "more than one". (It may be
> phrased "almost always one" but that is equivalent to "more than
> one").
>
> Your data modelers are doing the correct thing; I suspect that
> "improving" the data model by denormalizing all of those tables back
> into the customer table would cause more harm than good.
>
> If you can persuade the Data Modelers that performance in this case
> is more important than proper design, and the advantages outweigh the
> disadvantages you may be able to get the data model changed.
>
> --
> Kelly R. Burkhart
> kburk_at_sky.net
>
> [The litigation] industry was, of course, up and running before the
> tobacco litigation, but that taught lawyers just how lucrative it
> could be to blame individuals' foolishness on, say, Joe Camel.
> -- George F. Will
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Oct 31 1999 - 10:42:40 CST