Re: DB Design Principles for RDBMS

From: Paul Vernon <paul.vernon_at_ukk.ibmm.comm>
Date: Mon, 10 Feb 2003 12:07:25 -0000
Message-ID: <b284p4$hiu$1@sp15at20.hursley.ibm.com>

"Anton Versteeg" <anton_versteeg_at_nnll.iibbmm.com> wrote in message news:3E477A6C.B4CD774C_at_nnll.iibbmm.com...

or alternatively...

> 1. Keep it simple

Make it as complex as sufices to capture the detail of the thing being modeled

> 2. Know your data/business processes

Discover your data and processes (aka database constraints) during your design.

> 3. Use commen sense

Use rational and critical thinking

> 4. Do not over-normalize your database design

Normalise your design to the point where it makes the specification of most constraints easier

> 5. Spend enoug time on your conceptual/logical data model,
> because mistakes made there will be hard to correct.

Generate your logical design directly as a physical database, and then iterate.

;-)

Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Mon Feb 10 2003 - 06:07:25 CST