Entity Relations Designer in MyEclipse

1. Visualize Entity Relations with an ER Diagram

The MyEclipse Entity Relations Designer helps you visually manage the lifecycle of a relational database from design, through implementation, and maintenance. The MyEclipse ER-Designer provides a visual model of existing databases. The ER-Designer utilizes the database connectors of the Database Explorer to access a database’s metadata as it reverse engineers the database’s entity relations (ER) model. From that, the ER-Designer renders the model using the Information Engineering (IE) System for ER as an entity relation diagram (ERD). At any time, the ER-Designer can synchronize an ERD with its database to accurately reflect the current state of the database. The ER Design includes a sophisticated table and relationship layout engine that enables it to quickly lay out an ERD.

Entity relations designer in MyEclipse
Entity relations diagram

2. Notation and Presentation Basics

The ER-Designer supports Information Engineering for ER notation, a.k.a., crows feet notation. During the reverse engineering process, only the cardinality of the child entity of a parent-child relationship is depicted. The figure below depicts an annotated relation. Notice the details compartment of a table defines each table column, the column’s type, and its role, such as a primary or foreign key. The table below defines the meaning of the icons and text styles used in the table details compartment.

2.1 Positioning Tables

You can position a table in any location on the ER-Designer by dragging it to a new location. Any relocation operation can be reversed using the Eclipse Undo command or its equivalent keyboard shortcut (e.g., CTRL+Z). When a table is selected, it is presented with a distinct highlighted background color. In the image below, the JOBS table is selected.

example_entity_relationship
Example entity relationship

 
Example TableSymbol/Text StyleValue
Entity relations diagram in MyEclipseunderlined text +   or Primary Key
 or   Foreign Key
bold textNot NULL constraint
normal textNULL-able
 / Expand/Collapse details compartment

 2.2 Relationships

A relationship is depicted as a directed, labeled connection between two database table entities. The connection’s label is based on the pattern: parentTable(column1,…)= childTable(column1,…) mapping. Next to the relationship label is a direction arrow that points from the parent table to the child table (->). When you fly-over a connection, the foreign key constraint name is displayed. For example the JHIST_JOB_FK constraint is depicted above in the example entity relationship image, just below the relation in bright blue text. The table below describes ER-Designer relationship annotations.

Example SchemaSymbolDescription
Entity relations diagram in MyEclipseOne and only one
One or more
Zero or more
Zero or one


2.3 Visual Grid, Labels, Table Alignment and Table Resizing

The ER-Designer provides a visual grid, grid alignment and table sizing tools to help you manually layout tables and relationship routing in a uniform and aesthetically pleasing style.

Grid
To toggle the visual Grid feature on/off, select the ER-Designer, and select View>Grid from the menu.

visual_grid
Toggling the visual grid on and off

Snap to Grid
The Snap To Grid feature facilitates the manual alignment of tables and relationships by constraining their placement to align with vertical and horizontal grid lines. The grid is NOT required to be visible for this feature to be activated. To toggle the Snap to Grid feature on/off, select the ER-Designer, and select View>Snap To Grid from the menu.

snap_to_grid
Toggling snap to grid on and off

Relationship Labels
Labels for relationships between tables are shown by default. To toggle label visibily, select the ER-Designer,and select View>Relationship Labels from the menu. 

label_visibility
Toggling relationship label visibility on and off

Horizontal and Vertical Alignment Tools
The ER-Designer contributes table alignment tools to the MyEclipse toolbar. Select two or more tables you want to align, and select an alignment style from the MyEclipse toolbar.

alignment_tools
Toolbar table alignment styles

Table Resizing Tools
The ER-Designer contributes table resizing tools to the MyEclipse toolbar. Select two or more tables you want to resize, and select a resizing style from the MyEclipse toolbar.

resize_tools
Toolbar table resize styles

3. Table Location Features

Browsing a large entity relation diagram to locate tables can be tedious. To simplify this process the ER-Designer provides two table location features. The first is an Outline view that depicts the database tables in a tree list. The second is a Table Locator that provides fast table name search and location.

The image below shows the JOB_HISTORY table selected in the outline view and the corresponding ER digram table symbol highlighted and visible.

    Entity relations designer in MyEclipse
    Locating a table using the Outline view

    In addition to using the Outline view to locate tables, the ER-Designer provides the Table Locator, a pop-up window with a fast text search feature. Launch the Table Locator from either the ER-Designer’s right-click context menu, the Navigate menu bar, the Outline view toolbar, or by pressing ALT+F3

    Entity relations designer in MyEclipseTable Locator window


    4. ER-Designer Preferences

    You can customize the look-and-feel of the ER-Designer using the preference page. To access the ER-Designer preference page, select Window>Preferences, expand MyEclipse>Database Explorer and select ER-Designer.


    ER-Designer preference page

    5. Resources