Re: Treating addresses in 3NF?

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 with their postcode and address data, but rather gives those willing to *pay* for the data, a set of 'flat files' and some Cobol copybook definitions, so forcing us developers to (try to) create normalised models for their data?! No, surly not.

Surly what happens is that such prestigious organisations that 'own' data vital to the smooth running of the economy subscribe to an international standard on the exchange of data (that is obviously based on the relational model, being as it is, the 'best' way of logically representing data for multiple applications) and publish their data using such a standard, which (amongst many other things) would allow all databases that use this data to work off the same logical model

:-)

Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Tue Nov 12 2002 - 18:51:32 CET