Database Answers Pebble Beach Golf Course (click for Web Site)

Printer Printer-friendly version

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Customer Addresses
Back to the Data Model.

The Addresses Table shown in the Data Model is compatible with the two-line Standard recommended by the US Postal Service.
It is also compatible with the UK standard, which favors 4 lines.
Here's a discussion of the Universal Postal Union UPU S42 International Address Standard, published in 2003.

Wikipedia has an interesting article on Postal Code.

WorldVU specialises in advising on Worldwide Addressing and Mailing problems.

Waytag suggests a novel approach that "reduces long addresses to one simple word."
This is the reverse of what the British Post Office (and probably all the others) do when they break an Address down to basic components.
 
Barry Williams
January 18th. 2013
Principal Consultant
Database Answers
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map