Re: Modeling Address using Relational Theory

From: Gene Wirchenko <genew_at_ucantrade.com.NOTHERE>
Date: Thu, 01 Sep 2005 10:28:16 -0700
Message-ID: <gt9eh1libshopc1q5r1ugeulbjug61urgp_at_4ax.com>


On 1 Sep 2005 06:51:47 -0700, "dawn" <dawnwolthuis_at_gmail.com> wrote:

[snip]

>It really is easy to put address lines in a list, even if only the
>lines that end up as 2nd & 3rd on an address label. So, the components
>that might be rendered as an address label are often (in non-SQL
>implementations):
>
>MailToName (perhaps derived from title, first, middle, last, suffix,
>for example)
>AddressLines (multi-valued)

     Why? You could simply have an addresslines value that can extend over more than one line.

[snip]

Sincerely,

Gene Wirchenko Received on Thu Sep 01 2005 - 19:28:16 CEST

Original text of this message