13. ER Model Enhancements (Revision #117)

To design a complex Entity-Relationship (ER) Model with hundreds of entities and relationships, it becomes a difficult task for the Data Modeler to manually edit and rearrange each entity and organize relationship lines. New enhancements in ADS like editable entity colors, Hide relationship lines and Auto-fit entities has made it easier for the users to understand/print ER Models in Aqua Data Studio. 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.

Complex Entity-Relationship (ER) Models usually contains hundreds of entities and relationships. The process of modeling the requirement, manually editing and rearranging each entity into regions can be tedious. Trying to understand them at a glance is difficult, without specific visual clues for each entity in the model. If there are options to highlight tables, views with different colors, hide relationship lines as and when required and resize entities to fit contents, it becomes easier for the Data Modeler to organize the diagram. We have made it easier for the users to understand/print ER Models in Aqua Data Studio with new enhancements like editable entity colors, Hide relationship lines and Auto-fit entities. 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 relationship lines between entities is introduced

Generate Script

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