Re: Treating addresses in 3NF?
Date: Wed, 13 Nov 2002 14:51:31 -0000
Well 'AB12' -> POSTAL_TOWN
and POST_TOWN -> COUNTY
and COUNTY -> COUNTRY
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 www.royalmail.com 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:
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.
Business Intelligence, IBM Global Services Received on Wed Nov 13 2002 - 15:51:31 CET