Re: Help! I can't support normalization
Date: Tue, 05 Nov 2002 09:34:20 +0000
Message-ID: <f43fsug614b0rduae4d3mkmk0mlid5qlg0_at_4ax.com>
Rowan wrote:
>Greetings all,
>
>I have read with great interest the discussions regarding
>normalization. I understand it. I can do it. Unfortunately, I
>cannot convince the people I work with how important it is.
[snip]
> Please enlighten me!
Had the same problem and am slowly convincing my boss that change is needed.
It comes down to redundant fields in the db, maintenance of the db by anyone who wasnt around when was it created, the ability to add new tables referenced on key ID's elsewhere, integrety of data and the ease of query the db in any concievable way with a standard language such as SQL.
Large non-normalised databases are a nightmare, where i'm working they have an IS that is around 1gig at backup time and is spread over 7000+ different mdb's, to query you have to open a connection to each one individually and iterate through them... like I said; A NIGHTMARE!!! Received on Tue Nov 05 2002 - 10:34:20 CET