13. ER Model Enhancements (Revision #107)

Complex Entity-Relationship (ER) Models usually contains hundreds of entities and relationships.  The process of modeling the requirement, manually editing and rearranging each entities into regions can be tedious.  Trying to understand them at a glance is difficult, without vivid visual clues in the model to highlight and organize the relationships and tables. We have made it easier for the users to understand ER Models in Aqua Data Studio with new enhancements like Auto-fit entities, Hide relationship lines, editable entity colors. The ER Modeler we’ve built into Aqua Data Studio is as powerful as even the best standalone database diagramming tools. Use it to design a new database from scratch, understand and clean up a database nightmare in your office, or visually understand entity relationships in existing databases to write more effective SQL queries. 

What makes Aqua Data Studio the best standalone ER Modeling Tool ?

Create, Explore, Detail and Modify.

• Model a Database From Scratch
• Clean Up A Database Mess
• Visually Understand a Database
• Supports all major databases and versions including: Oracle, DB2 for LUW, DB2 for iSeries, MS SQL Server, Sybase ASE, Sybase IQ, Sybase Anywhere, Informix, PostgreSQL and MySQL.
• Allows for Forward and Reverse Engineering of database schema — create a database from an ER diagram, or extract a diagram from an existing database. 
• Save, modify, annotate and share diagrams with groups while tracking modifications.

What's New?

Appearance Tab	Entity Color	Auto-Fit Entities with Alt+A	Contents Resized	@ separator

Editable Entity Colors and Region Foreground Colors

The color of Table and View Entities can now be set on a per-entity basis by changing it within the Property Appearance tab. Regions now allow their text color to be altered with Foreground color selection.

Auto-Fit Entities

Selected entities can be automatically resized to fit their contents, by using the menu Edit -> Auto-Fit or the keystroke Alt+A

Hide Relationship

New enhancement to hide relationships between entities is introduced

Generate Script

Now there is a statement separator option for "@" just like Schema Script Generator.