DB normalizer project DMKM
Following features:
- Import of database schemes (metadata) from a database instance; if no database connection is available, relational schemes may be prompted manually
- Specification and editing of functional dependencies (FDs)
- Testing if a given set of FDs is satisfied in a database table (only if a database connection is available)
- Computation of a minimal cover
- Determination of the attribute closure for a given attribute set
- Calculation of all candidate keys
- Normal Form (NF) testing from 1NF up to BCNF; FDs which violate a certain NF are reported to the user
Generation of a normalization proposal: synthesis of relations in 3NF is guaranteed; BCNF synthesis may be possible. Normalization includes computation of:
- the new relations
- functional dependencies for the new relations
- all candidate keys for the new relations
- foreign key dependencies between the new relations
- normal forms of the new relations (3NF or BCNF)
- If a database connection is established, a SQL script for database transformation is created. This script includes
- DDL statements to create the new tables
- DML statements to migrate data from the old table to the new tables
- DDL statements to delete the old table
- DDL statements to add foreign key and constraints to the new tables
- DDL statements for view generation to ease the porting of existing database apllications
- Import and export of FDs and database schemes as XML files
- Import of FDs, automatically retrieved from a database