Re: DB Design Principles for RDBMS

I guess we agree :)

Paul Vernon wrote:

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

--
Anton Versteeg
DB2 Specialist
IBM Netherlands