Home

Database-Analyzer:

Java/Swing based Database Management Tool, to create a basic layout of your database (including relations, attributes, attribute types and functional dependencies). From this created layout you can get the current normalform of the database and each relation. Relations can be normalized into a higher NF, up to BCNF. It also includes a graphical representation of the database.

Informations:

• GPL v3
• Java 7 with Swing GUI

Features:

• Create Relations, Attributes, FDs
• Set PKs, FKs
• Edit all elements (edit, rename, delete,...)
• Userfriendly, fast and intuitive
• Inspection of current database, including: Current NF (1NF, 2NF, 3NF, BCNF) Key Canidates FDs, Attributes violating higher NF
• Normalization into a higher NF (up to BCNF)
• Customer Informations, Notes,...
• Graphical representation of database - Relation view (with FKs) and FDs view
• Export in TXT and PNG
• Undo/Redo
• Multilanguage (English, German, more will follow maybe)

TODO:

• Read relations from database (mysql, postgres,...)
• Create SQL Dump from current database
• Import database (including all informations)
• Modify imported database with keeping dataitegrity
• Export database back
• UI improvements
• Bugfixing
• More languages
• MUCH MORE