Re: Treating addresses in 3NF?

From: Paul Vernon <paul.vernon_at_ukk.ibmm.comm>
Date: Sun, 17 Nov 2002 22:38:05 -0000
Message-ID: <ar95q6$lkg$3_at_sp15at20.hursley.ibm.com>


"--CELKO--" <71062.1056_at_compuserve.com> wrote in message news:c0d87ec0.0211161840.68e5e66e_at_posting.google.com...
> >> 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.

Thanks Joe, although my point is that you don't get a relational model for your 150 or 500 pounds. Why is that? Why no international standard on relational database model descriptions?

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.

Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Sun Nov 17 2002 - 23:38:05 CET

Original text of this message