Re: Normalization and DBMS

From: Alfredo Novoa <alfredo_at_ncs.es>
Date: Wed, 12 May 2004 15:02:44 GMT
Message-ID: <40a23923.27106146@news-read3.maxwell.syr.edu>

On Wed, 12 May 2004 09:23:44 -0500, "Dawn M. Wolthuis" <dwolt_at_tincat-group.com> wrote:

>According to the new definitions of normalization by folks such as Date,
>relation-valued attributes are now acceptable.

But not very useful in base tables.

> So, the OO, XML, PICK and/or
>others who have accepted non-1NF data structures in spite of tremendous
>pressure from the SQL-DBMS folks to do otherwise just might have had some
>little influence in helping relational theory be a bit more useful.

Perhaps, but they are still fundamentally wrong.

>course, it is also possible that relational theorists, when looking at the
>theory itself saw that there was nothing logical about excluding "repeating
>groups"

Repeating groups like in Leandro's example are a very bad practice, but they don't have relationship with 1NF.

Regards
Alfredo Received on Wed May 12 2004 - 10:02:44 CDT