Re: Normalisation
From: Jon Heggland <heggland_at_idi.ntnu.no>
Date: Sat, 2 Jul 2005 20:04:06 +0200
Message-ID: <MPG.1d30f54239ed91709896ce_at_news.ntnu.no>
Date: Sat, 2 Jul 2005 20:04:06 +0200
Message-ID: <MPG.1d30f54239ed91709896ce_at_news.ntnu.no>
In article <jfwxe.135559$Sl.7259257_at_phobos.telenet-ops.be>,
jan.hidders_at_REMOVETHIS.pandora.be says...
> > In theory, set-valued fields definitely do not violate 1NF.
>
> That's only true if you accept Chris Date's redefinition of the "first
> normal form", and that is by no means widely accepted as *the*
> definition in academia and industry, and I don't see that changing
> anytime in the near future.
Well, the "atomicity" definition doesn't hold up under scrutiny, and the "you shouldn't have more than one column about the same thing" definition is too informal. Unfortunately, it's not all that relevant in practise, since domain support is so bad, and I don't see *that* changing anytime in the near future.
-- JonReceived on Sat Jul 02 2005 - 20:04:06 CEST