Re: Modeling Address using Relational Theory

-CELKO- wrote:
> Look at the US Postal Service specs. You use a five line label with 35
> characters per lines. ZIP+4 is CHAR(9), the State code is CHAR(2) and
> so forth.

Yes, I've got the "representation specs" for an address on an envelope, but what is the logical relational model related to such addresses? Again, you can skip the city, state, country, and postcode unless they are not modeled with attributes such as city, state, ...

What is a good relational data model for the rest of the address? --dawn Received on Mon Aug 29 2005 - 02:38:32 CEST