Re: DB Design Principles for RDBMS
Date: Mon, 10 Feb 2003 12:07:25 -0000
Message-ID: <b284p4$hiu$1_at_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 - 13:07:25 CET