Re: Modeling Address using Relational Theory

dawn wrote:

> -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

Dawn, there is no 'relational version' of the information, it is what it is.
Put into a fixed-field width text file there would be fields, in an XML
file there would be elements or tags or whatever, and in a table they would
be columns.

An address is not subdividable in any way that requires normalization, that
is why there is no "normalized" or "relational" way to store an address.
--
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec)ure(Dat)a(.com)
.

Relevant Pages

  • Re: Proposal: 6NF
    ... You said it Dawn! ... you've been ignoring all of us ... who have been trying to teach you that the relational data model is, ... which is a shame. ...
    (comp.databases.theory)
  • Re: "Backyard chickens on the rise ...."
    ... The neighbors had an ass that would wind up at dawn to ear splitting, ... I stayed in the city for a week not long ago. ...
    (misc.rural)
  • RE: Auto generate sheets by different values of a cell.
    ... For Each city In UniqueCities ... "Dawn" wrote: ... I want to use excel to auto generate sheets according to the value of the ...
    (microsoft.public.excel.misc)
  • Re: Cauliflower turns green
    ... of dawn! ... There is a newish farmer's market near you..and it starts at a decent ... hour..and goes til afternoon, I think. ... And that is not the only one in the city or the ...
    (rec.food.cooking)