Re: Modeling Address using Relational Theory

From: Gene Wirchenko <genew_at_ucantrade.com.NOTHERE>
Date: Tue, 30 Aug 2005 09:43:57 -0700
Message-ID: <mk29h1tkse33hn742f0cba1k4tavldiiu1_at_4ax.com>


On 29 Aug 2005 20:49:44 -0700, "dawn" <dawnwolthuis_at_gmail.com> wrote:

>AK wrote:
>> it will be a little bit country specific. You could limit your
>> application for only one country. Or if you cannot figure out all the
>> details for all the countries up front, you might be better off with
>> Line1, Line2, Line3. Alternatively you could plan to have country
>> specific versions
>
>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.

[snip]

Sincerely,

Gene Wirchenko Received on Tue Aug 30 2005 - 18:43:57 CEST

Original text of this message