Re: Tools for automated normalization ?
Date: Mon, 2 May 2005 07:36:46 -0500
Message-ID: <zsWdnTBkZvFCsuvfRVn-2Q_at_comcast.com>
Hi Tom,
> 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.
This isn't a normalization tool per se, but you might be interested all the same....
Object-Role Modeling (ORM) models objects playing roles in fact types that are "elementary", or, in other words, functional dependencies. Thus, you could use an ORM tool to enter your functional dependencies (fact types), supply a few constraints to describe the relationship between the object types in each fact type, and generate a normalized RDBMS schema (using, say, Visio or the now free VisioModeler/Infomodeler).
Hope that helps,
Scot.
...............................................Scot Becker
Orthogonal Software
www.orthogonalsoftware.com
ORM Blog/Portal: www.objectrolemodeling.com
To e-mail me, please use my first name at the domain listed above. All mail sent to the reply-to address gets routed to a junk e-mail folder where it will likely be deleted without being read. Received on Mon May 02 2005 - 14:36:46 CEST