Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.glorb.com!logbridge.uoregon.edu!arclight.uoregon.edu!wn51feed!worldnet.att.net!216.168.1.162!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: "Tom Hester" <$$tom@metadata.com> Newsgroups: comp.databases.theory Subject: Re: Codd provided appropriate mathematics ... (was Re: Relational and MV (response to "foundations of relational theory")) Date: Thu, 26 Feb 2004 10:58:40 -0800 Organization: We Message-ID: ath: meganewsservers.com References: <4b45d3ad.0402181740.42d42bc2@posting.google.com> <23ccd$403cc30f$45033832$15956@msgid.meganewsservers.com> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Complaints-To: abuse@supernews.com Lines: 21 Xref: newssvr20.news.prodigy.com comp.databases.theory:24098 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" wrote in message news:k6r%b.50112$LX2.42031@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? > >