UserManual

System Requirements

• Java 1.7
• Windows, OS X, Linux

User Manual

Editing Database

You can edit your Database, via the context sensitive toolbar or via right-clicking a element in the tree. See imgage.

Functions on Database:

• Create a new Relation with a Wizard
• Create a new (empty) Relation
• Check (inspect) the database for errors, warnings and the current normalform

Functions on Relation:

• Add Attributes
• Add Functional Dependencies (only if 2 or more Relations are in Database)
• Edit the selected Relation with a wizard
• Delete Relation
• Rename Relation
• Inspect Relation
• Optimize Relation (up to BCNF, only available if Relation is 1NF, 2NF or 3NF)

Functions on Attributes:

• Delete Attribute
• Rename Attribute
• Set Primary Key
• Set Foreign Key
• Set Data Type (preperation for DB connection)

Function on FDs:

• Edit Functional Dependency
• Delete Functional Dependency

Customer Informations

Customer informations, contact data and note to the project can be stored via Edit/Customer Informations

The current date, contact persons and relation name can be inserted into the note, for a faster change tracking.

Export

The created Database can be exported (File/Export as...) to the following formats:

• HTML Report: contains customer company, address, contacts, notes, ER-Diagram, FD-Diagram and a textual description of the database. HERE is an example
• PNG: a picture of the ER-Diagram and FD-Diagram
• TXT: a textual description of the database