ER Modeler (Revision #60)

Then Entity Relationship (ER) Modeler has been completely redesigned, including enough new features and enhancements that it is as powerful as a stand-alone database diagramming tool. Any database you access through Aqua Data Studio can be accessed and diagrammed within the ER Modeler. The ER Modeler’s resulting ER (Entity Relationship) Diagrams are editable drawings of database relationships and objects where database schemas can be created, explored, detailed, edited and understood.

Changes made to an ER Diagram can be automatically scripted to make the associated changes in database schema. Database content can also automatcially diagrammed with only a few clicks.  Manipulation of the resulting diagrams alters the relationships and objects of the corresponding database.  Using the ER Modeler in this fashion greatly reduces development time and vastly increases developers’ understanding of database schemas and relationships.  Sharing a diagram with a team, through Aqua Data Studio’s integrated source control clients, makes collaboration on schema changes easy and instantly creates an archive of team progress.

ER Modeler	Generate ER Diagram	Alter Table Properties	Create New	Dockable Framework

Operations Overview

• Creating a New Diagram: New diagrams can be created manually by drawing entities on a sheet and altering their attributes.
• Extracting a Diagram From a Database: A diagram can be extracted from an existing database, its schema objects quickly drawn for modification or
• Saving, Modifying and Sharing Diagrams: Diagrams can be saved, opened, documented, modified and shared with groups. When a diagram is added to the script mount for a database server, the mount can be included in a source control repository. All of the developers in an organization can then access the same model, modify it and track the modifications.
• Printing Diagrams: Once a diagram is complete, it can be printed, enlarged and laminated for use as a poster for quick reference.
• Saving a Diagram As an Image: The diagram can also be saved as a JPG or PNG image for inclusion in word processing documents or presentation slides.

 Workspace and Dockable Framework Overview

• Model Node Browser: Presents all of the objects within a diagram in a tree containing all relationships, tables, views and notes. The tree can be expanded or collapsed to display more detailed information such as Indexes and Constraints.
• Sheet: Shows the diagram contents in independent views for manual or automatic layout. This is the drawing area of the ER Diagram. Objects can display on more than one sheet at a time.
• Object Properties Pane: Displays, in noneditable form, the properties of the selected object or objects.
• Overview: A bird’s eye view of the current sheet, allowing fast navigation with a draggable and resizeable zoom rectangle. The rectangle indicates what is displaying in the current sheet.

Entity Relationship (ER) Modeler Detailed Actions List