Re: Database design

From: Scot A. Becker <scotb_at_inconcept.com>
Date: 2000/01/01
Message-ID: <vjdb4.355$Za6.76876_at_typhoon3.rdc-detw.rr.com>#1/1


"Robert Kolker" <rkolker_at_concord.com> wrote in message news:386CE067.95E227C6_at_concord.com...

> You can't do relational database design without knowing something about
normalization.

Being a bit of a nitpick , this isn't quite right.

Using Object-Role Modeling, one doesn't need to know anything about formal normalization. ORM's (elementary) fact based approach insures that the resulting logical (ER) schema is in "optimal" normal form, which, in practice, is at least 4NF, and often 5NF (because ORM captures more rules than ER approaches, many 5NF errors are also avoided).

I've written a bit more about this topic at the URLs below. Specifically, the articles can be found at
http://www.inconcept.com/JCM/June1999/becker.html and http://www.inconcept.com/JCM/August1998/becker.html.

HTH,
Scot.



Scot A. Becker

Principal Consultant, InConcept, Inc.

     http://www.inconcept.com

Editor, The Journal of Conceptual Modeling

     http://www.inconcept.com/JCM Received on Sat Jan 01 2000 - 00:00:00 CET

Original text of this message