> > you're usually much better off with a fully normalized database.
>
> when you say "fully" do you mean we should strive for
> third-normal form? Or should be be stretching to go further?
>
> (reporting issues aside--I mean what should we shoot for
> unless we have a reason not to?)
Fourth and fifth normal forms only apply to pretty unusual circumstances,
but if those circumstances occur, I'd usually recommend normalization to the
greatest degree possible. For most databases, third normal form is as
normalized as they can get.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
