Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!ames!apple!agate!helios.ee.lbl.gov!nosc!cod!dberg
From: dberg@cod.NOSC.MIL (David I. Berg)
Newsgroups: comp.databases
Subject: Re: Do you normalize?
Summary: I ALWAYS normalize
Keywords: normalization
Message-ID: <1581@cod.NOSC.MIL>
Date: 19 Jul 89 19:20:51 GMT
References: <242@6sigma.UUCP>
Organization: Naval Ocean Systems Center, San Diego
Lines: 18

In article <242@6sigma.UUCP>, blm@6sigma.UUCP (Brian Matthews) writes:
> Do you normalize your databases? 

I always normalize.  Remember, a database is a mapping of a bounded enterprise
environment.  Each relation, or table, in the database is mapped from some
entity set or object type in the enterprise.  If you want your database to
accurately map the enterprise it represents, you will normalize it.  (And
this is true for any database supporting any application.)   When
your users apply logical transactions against the database, they will properly
reflect the actual operation that generated the transaction.

I usually normalize to 3NF, I do it by hand, and I use INFORMIX.

-- 
David I. Berg (dberg@nosc.mil)
GENISYS Information Systems, Inc., 4250 Pacific Hwy #118, San Diego, CA 92110
MILNET: dberg@nosc.mil
UUCP:   {akgua decvax dcdwest ucbvax}!sdcsvax!noscvax!dberg