Re: Which normal form is this violating?
From: Jan Hidders <hidders_at_uia.ua.ac.be>
Date: Thu, 25 Apr 2002 16:39:04 +0200
Message-ID: <3cc814e9$1_at_news.uia.ac.be>
> I don't agree with you. Having a table with just a PK is as far as I am
> concerned nonsense. In practice you have indexes for those things.
Date: Thu, 25 Apr 2002 16:39:04 +0200
Message-ID: <3cc814e9$1_at_news.uia.ac.be>
"Anton Versteeg" <Anton_Versteeg_at_nl.ibm> wrote in message news:3CC7F080.B2B1AFF1_at_nl.ibm...
>
> I don't agree with you. Having a table with just a PK is as far as I am
> concerned nonsense. In practice you have indexes for those things.
The point is that you avoid having fields with null values and thereby all those funny little semantical compexities that they cause.
> Overnormalizing usually creates unworkable, bad performing database
> designs.
That sound a bit like the definition of over-normalizing and would therefore be tautologically true. ;-)
- Jan Hidders