Re: Help with Database design

refer to Henry Korth's book of database design or else show them practically ..in the sense take their tables and u urself design a table and run a querry and that would prove it ! Regards
Parvinder

Eric wrote:

> I am a new employee at this company and I need help
> in explaining to the Data Modelers that their designs are not good.
>
> They will take a customer table and split it out into:
> customer
> email
> phone
> address
> etc...
>
> So when queries take place, a 5+ table join must occur.
> Does anyone have any quick stats on the overheads of joins?
> They tell me they split this up because they need to store history.
>
> How can I explain this to them that they need 1 customer table
> and maybe a history table. (since the history hardly ever gets queried)
>
> Thanks in advance!
Received on Fri Nov 26 1999 - 02:37:52 CST