Re: Modeling Address using Relational Theory

From: Marshall Spight <marshall.spight_at_gmail.com>
Date: 30 Aug 2005 10:48:16 -0700
Message-ID: <1125424096.771379.282440_at_g49g2000cwa.googlegroups.com>


Gene Wirchenko wrote:
> On 29 Aug 2005 20:49:44 -0700, "dawn" <dawnwolthuis_at_gmail.com> wrote:
> >
> >I understand the Line1, Line2, Line3 implementation, but any model with
> >those attributes screams "this model is not relational", right? I am
>
> No. It is not 1NF if the attributes can have other than one
> value, but the names are irrelevant except that they be unique within
> the relation.

Agreed. Line1 and Line2 are not two interchangable instances of the same kind of thing; they are specific distinct fields. It is not a repeating group.

Marshall Received on Tue Aug 30 2005 - 19:48:16 CEST

Original text of this message