Re: DB Design Principles for RDBMS
Date: Fri, 7 Mar 2003 08:48:56 -0000
"Tony" <andrewst_at_onetel.net.uk> wrote in message
> Anton Versteeg <anton_versteeg_at_nnll.iibbmm.com> wrote in message
> > 4. Do not over-normalize your database design
> I'm not sure how useful that advice is to someone new to database
> design. They may think: "Hmmm... having to join from order_line to
> order to get the customer name is a bit much - let's not take
> normalisation THAT far!"
I read somewhere that it is a good idea to start with a fully normalised db then selectively denormalise only when you have a good reason to do so.
Stu Received on Fri Mar 07 2003 - 09:48:56 CET