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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Views for denomalizing

Re: Views for denomalizing

From: Alfredo Novoa <alfredo_novoa_at_hotmail.com>
Date: Fri, 04 Feb 2005 15:03:18 +0100
Message-ID: <t407015adk2hcvr56sh04an51rv85fjgfv@4ax.com>


On 2 Feb 2005 22:34:47 -0800, lauri.pietarinen_at_atbusiness.com wrote:

>1NF is just another way to say that all data must be perceived as
>relations,

That is the Information Principle, not 1NF.

The Information Principle is a prerequsite to normalization.

IMO 1NF is supefluous and only exists due to historical reasons. Normalization starts with 2NF.

>and relations, by definition do NOT have duplicate tuples (or rows, in
>SQL-speak).

Nor nulls.

Regards Received on Fri Feb 04 2005 - 08:03:18 CST

Original text of this message

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