Re: Codd provided appropriate mathematics ... (was Re: Relational and MV (response to "foundations of relational theory"))

From: Tom Hester <$$tom_at_metadata.com>
Date: Thu, 26 Feb 2004 10:58:40 -0800
Message-ID: <aff87$403e41e1$45033832$6812_at_msgid.meganewsservers.com>


Both are non-1NF. Codd defines first normal form in terms of simple domains. That is the interpretation of a single element in a domain can only be an atomic element of a set. It cannot be further decomposed.

"Eric Kaun" <ekaun_at_yahoo.com> wrote in message news:k6r%b.50112$LX2.42031_at_newssvr33.news.prodigy.com...
> As an aside in this discussion, I've seen "multivalued" defined 2
different
> ways in explanations of relational (some of which are really bad).
>
> 1. Where attribute A can hold a list of values (type LIST)
> 2. Where there are attributes A1, A2, A3, A4 (for example), all of the
same
> type and meaning. For example, ADDR1, ADDR2, etc.
>
> Does 1NF refer to both of these? If not, what's the proper terminology for
> each of these cases?
>
>
Received on Thu Feb 26 2004 - 19:58:40 CET

Original text of this message