Tool for Database Design

A good database design depends on tools required to minimize redundancy and anomalies, preserve known functional dependencies, prevent spurious information from emerging, and identifying keys. Below is a tool created with these aims in mind. Specifically...

1. The closure of a list of attributes under a list of known functional dependencies is a complete list of attributes that can be functionally determined from the original list of attributes and the known dependencies. Input a set of attributes separated by commas and a list of known functional dependencies as instructed below to see this calculation performed.
2. A key of a relation is that attribute or minimal set of attributes that functionally determine all other attributes in the relation. Input a set of attributes separated by commas and a list of known functional dependencies as instructed below to see this calculation performed.
3. Minimal cover seeks to remove all redundant attributes and functional dependencies from a given set of functional dependencies in such a way that the reduced set of functional dependencies is equivalent to the given set of functional dependencies. Input a list of known functional dependencies as instructed below to see this calculation performed.
4. It is possible to take a universal relation and decompose it into many relations such that each of the resultant relations are in 3NF, do not sacrifice any of the known functional dependencies, with no information lost in the process. Input a set of attributes separated by commas and a list of known functional dependencies as instructed below to see this calculation performed.

Important to keep in mind is the order of attributes and functional dependencies entered matters and that such things like the key or minimal cover determined can depend on it.

If you enjoy this database design tool, also please consider reviewing my B+ Tree Simulator

Please leave a comment, make a suggestion and/or report a bug