Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Which normal form is this violating?

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@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. ;-)

Received on Thu Apr 25 2002 - 09:39:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US