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
