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$>

"Anton Versteeg" <> wrote in message

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.


Paul Vernon
Business Intelligence, IBM Global Services Received on Mon Feb 10 2003 - 13:07:25 CET

Original text of this message