Help with Database design

From: Eric <admin_at_t10.net>
Date: Sat, 30 Oct 1999 15:48:41 -0600
Message-ID: <WGJS3.40$Pf3.6406@news.uswest.net>

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 Sat Oct 30 1999 - 16:48:41 CDT