At 10:21 AM +0100 4/25/01, DeVoil, Nick wrote:
>I think you'll save yourself a lot of trouble later if you
>do a normalised database design with all necessary tables,
>columns etc and access them individually.
>
>Nick
>
Great advice... the database should reflect the structure of the
data, not impose an artificial one.
A little time spent up front will avoid many "horrors" down the road.
You can't imagine the convoluted gyrations necessary to
manipulate/maintain data in a poorly designed database.
If you choose to de-normalize, it should be a conscious decision made
after considering the alternatives and their impact over time....
It is pretty easy to fix a bad database design... much more difficult
to re-engineer a lot of programs that use that bad design.
HTH
Dick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
