Re: Modeling Address using Relational Theory

On 7 Sep 2005 11:00:37 -0700, "dawn" <dawnwolthuis_at_gmail.com> wrote:

>Gene Wirchenko wrote:

[snip]

>> Chinese addresses are that way though. They go from least to
>> most specific.
>>
>> Is this address issue really any different than Chinese (and some
>> other) names which have the family name first?
>
>I think it is slightly different.
>
>While names are at least as complex as addresses, I have found them to
>be slightly better behaved in that you can identify the attributes and
>constraints reasonably cleanly and then handle the differences as
>representation issues.

     They still have messy bits. Is "Lee Ann Smith"

1. surname "Smith", first name "Lee Ann";
2. surname "Smith", first name "Lee", middle name "Ann"; or
3. surname "Lee", first name "Lee", middle name "Ann"?

     How about "Mackie" and "MacKie"? This is an issue when names have been put into all-caps and you wish to reverse it.

[snip]

Sincerely,

Gene Wirchenko Received on Thu Sep 08 2005 - 19:41:26 CEST