Re: Treating addresses in 3NF?
Date: Sun, 17 Nov 2002 22:38:05 -0000
"--CELKO--" <71062.1056_at_compuserve.com> wrote in message
> >> You mean to tell me that a prestigious, highly efficient
> organisation like the British Royal Mail does not provide everyone
> with a fully normalised relational model ... <<
> For 'UK postcode databases', the Royal Mail holds the copyright and
> will licence you an 'outwards' database (i.e. the first segment of the
> full postcode) for about 150 UK pounds a year, or an 'inwards'
> database (i.e. the full 9- or 10-character postcode) for about 500 UK
> pounds per year.
Also, it always occurs to me that it must cost the Royal Mail much more because of the inefficiency due to baldy addressed post than they could ever make from selling their postcodes. I.e. if the postcode database was free, more post would be address correctly and they would *save* money. But then I should not expect to see much sense from a publicly owned organisation.
Business Intelligence, IBM Global Services Received on Sun Nov 17 2002 - 23:38:05 CET