Re: Tools for automated normalization ?

Tom wrote:
> Are there any tools (either some software with a GUI or a class
> library component in java or .NET to be reused) that can be used to
> automatically normalize a relational database ?
>
> The input should be a list of functional dependencies between the
> attributes/columns, and the output should be a list of suggested
> relations/tables that are normalized to at least the 3rd normal form.
>
> The theories and algorithms for normalizations has been around for
> quite some time now, I believe, so it seems strange to me if no good
> commercial or open source implementations have yet been created...

I think this is because nobody actually normalizes the way the theory is explained, that is go from relations in 1NF, check them for anomalies and subsequently normalize this set into 2NF etcetera. The only way I've ever seen the normal forms used is to validate/critisize a design proposal. Received on Mon May 02 2005 - 19:04:34 CEST