Re: Modeling Address using Relational Theory
- From: Gene Wirchenko <genew@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 30 Aug 2005 09:43:57 -0700
On 29 Aug 2005 20:49:44 -0700, "dawn" <dawnwolthuis@xxxxxxxxx> 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
.
- Follow-Ups:
- Re: Modeling Address using Relational Theory
- From: Marshall Spight
- Re: Modeling Address using Relational Theory
- References:
- Modeling Address using Relational Theory
- From: dawn
- Re: Modeling Address using Relational Theory
- From: AK
- Re: Modeling Address using Relational Theory
- From: dawn
- Modeling Address using Relational Theory
- Prev by Date: Re: Identity modelling (was: dbdebunk 'Quote of Week' comment)
- Next by Date: Re: Identity modelling (was: dbdebunk 'Quote of Week' comment)
- Previous by thread: Re: Modeling Address using Relational Theory
- Next by thread: Re: Modeling Address using Relational Theory
- Index(es):
Relevant Pages
|