Re: Modeling Address using Relational Theory

On 26 Aug 2005 20:58:04 -0700, "dawn" <dawnwolthuis_at_gmail.com> wrote:

[snip]
>What I keep seeing in self-described relational models is Line1, Line2,
>Line3. That just seems wrong. What would be the purest relational
>approach to this?

To express our understanding of addresses in the real world in terms of a logical data model. In other words, I'd do a conceptual model first, then translate it into a relational model. Gaining the understanding you need about how addresses work in the real world is beyond the scope of the relational model.

I get the feeling that a lot of people in this thread think an address and a mailing label are the same thing. They aren't.

-- 
Mike Sherrill