3NF depends on "The Key, the whole key, and nothing but the ley... so
help me Codd"
I have found an excellent chapter in Martin Gruber's "Mastering SQL"
about the various stages of normalization... and they are just that,
stages!... a database is not usually thought of "Normalized" or
"Denormalized"... rather in some stage of normalization... this is a
subtle designation. as you can usually determine if a database
contains some denormalization... but you can't determine that it
doesn't?
HTH
Dick
At 9:45 PM -0700 4/15/01, Jeffry Houser wrote:
>At 07:21 PM 04/15/2001 -0400, you wrote:
>> > you're usually much better off with a fully normalized database.
>> >
>>
>>Dave,
>>
>>when you say "fully" do you mean we should strive for third-normal form? Or
>>should be be stretching to go further?
>
> Did you mean third, or fifth normal form?
> I always shoot for Domain/Key normal form. Which, means, basically,
>that there are no insertion or deletion anomalies in my table structure,
>and that table structure will depend upon the application. Anomalies can
>exist for one application that a different application may never experience.
>
> If I had to tell you specifically what each normal form was, I wouldn't
>be able to do it, but I think I've become pretty good at avoiding anomalies.
>
>
>Jeffry Houser | mailto:[EMAIL PROTECTED]
>AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
>--
>Instant ColdFusion 5.0 | ISBN: 0-07-213238-8
>Due out June 2001
>--
>DotComIt, LLC
>database driven web data using ColdFusion, Lotus Notes/Domino
>--
>Half of the Alternative Folk Duo called Far Cry Fly
>http://www.farcryfly.com | http://www.mp3.com/FarCryFly
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
