Re: Treating addresses in 3NF?

From: Paul Vernon <paul.vernon_at_ukk.ibmm.comm>
Date: Wed, 13 Nov 2002 14:51:31 -0000
Message-ID: <aqtovb$13ra$>

"Paul" <> wrote in message
> Now AB12 will always be in the county of Countyshire.

Well 'AB12' -> POSTAL_TOWN

but AB12 does not impliy that your house is actually in COUNTY, nor for that matter COUNTRY.

E.g. Search for 'HOME FARM' in 'SY13' on the address finder on and, although they do not show COUNTRY, I know that half of those farms are in Wales and half in England!

If anyone is serious about UK postal addresses, you need to digest: 5_0.pdf

And try to find all the hidden functional dependencies :-)

Then try the same for the 200 or so other other postal address 'standards' around the world.

Paul Vernon
Business Intelligence, IBM Global Services Received on Wed Nov 13 2002 - 15:51:31 CET

Original text of this message