Re: Normalization and DBMS

From: Leandro Guimarães Faria Corsetti Dutra <leandro_at_dutra.fastmail.fm>
Date: Wed, 12 May 2004 10:11:27 -0300
Message-ID: <pan.2004.05.12.13.11.27.5485@dutra.fastmail.fm>

Em Wed, 12 May 2004 08:50:43 +0000, Alfredo Novoa escreveu:

>> 1NF was initially applied to clean our databases of such
>>horrors as:
>>
>> CREATE TABLE
>>(
>> subject,
>> year,
>> grade_jan,
>> grade_feb,
>> ...
>>)

>
> Yes, but this table is in 1NF.

So back to the textbooks...

Normalisation apart would you still agree it is a good thing to get rid of repeating groups? On which theoretical basis if any?

-- 
Leandro GuimarÃ£es Faria Corsetti Dutra           +55 (11) 5685 2219
Av Sgto Geraldo Santana, 1100 6/71               +55 (11) 5686 9607
04.674-000  SÃ£o Paulo, SP                                    BRASIL
http://br.geocities.com./lgcdutra/

Received on Wed May 12 2004 - 08:11:27 CDT