Skip to content

bmharsha/DBNormalizer

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DBNormalizer

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

About

DB normalizer project DMKM

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%