× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases

×

ER Modeler (Revision #52)

Then ER Modeler has been completely redesigned, including enough new features and enhancements that it is as powerful as a stand-alone database diagramming tool. 

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

Menu Bar - Contains all of the menus available in the ER Modeler.
  • File
    • New - Creates a new, blank ER Diagram.
    • Open - Opens an exisitng ER Diagram.
    • Save - Saves the current diagram.
    • Save As - Saves the current diagram with a different filename.
    • Save As Image - Saves the current sheet view as PNG or JPG.
    • Generate Script - Generates the SQL required to script the diagram.
    • Print - Prints the current sheet.
    • Close - Closes the current diagram.
  • Edit
    • Copy - Copies the selected entity object or content.
    • Paste - Pastes the entity object or content in the clipboard.
    • New Table - Creates a new table entity object.
    • New View - Creates a new view.
    • New Note - Creates a new note.
    • New Relationship - Creates a new relationship.
    • New Subcategory - Creates a new subcategory.
    • New Region - Creates a new region.
  • View
    • Zoom: 1:1 Scale - Zooms current view to actual size.
    • Zoom: In - Magnifies the current view.
    • Zoom: Out - Shrinks the current view.
    • Zoom: Panorama - Forces the the entire sheet to fit in the Sheet.
  • Sheet
    • Add Sheet - Adds a sheet to the current diagram.
    • Rename Sheet - Renames the selected sheet.
    • Layout - Allows selection of different automatic layout of entities.
    • Delete Sheet - Deletes the current sheet.
  • Display
    • Attribute Level - Displays only the entity object attributes.
    • Primary Key Level - Displays only the Primary Keys.
    • Entity Level - Displays only the entities.
    • Physical Schema Level - Displays the Data Types.
    • Comments - Displays the comments associated with an entity.
    • Relationship Names - Displays the names or relationships.
  • Window
    • Hide Model - Hides the Model Node Browser.
    • Hide Object Properties - Hides the Objects Properties pane.
    • Hide Overview - Hides the Overview.
    • Hide Palette - Hides the Entity Palette.
Tool Bar - Contains button icons of the tools of the ER Modeler.
  • Save - Saves the current ER Diagram.
  • Print - launches print dialog.
  • Zoom: 1:1 Scale - Zooms current view to actual size.
  • Zoom: In - Magnifies the current view.
  • Zoom: Out - Shrinks the current view.
  • Zoom: Panorama - Zooms out until the entire diagram fits in the sheet.
  • Display Attribute Level - Displays entities and their attributes.
  • Display Primary Key Level - Displays entities and their primary keys.
  • Display Entity Level - Displays on entities by name.
  • Display Physical Schema Level - Displays or hides the physical schema level.
  • Display Comments - Displays or hides the comments.
  • Display Relationship Names - Displays or hides the names of relationships.
Model Browser - Contains a node view of all entities and objects within a diagram. Objects hidden in the current sheet are gray.
Sheet View - Contains all of the sheets of a diagram, each indicated with a tab. This is where the diagram displays. Objects can display on multiple sheets and can be layed out differently on each one without altering the layout of the other sheets.
Entity Palette - Contains all of the entities which may be created within a sheet, including Tables, Views, Notes, Relationships, and Regions.
Model Overview - Contains a thumbnail of the entire active sheet. A red rectangle indicates what portion of the thumbnail is being viewed. Moving this rectangle changes the area visible in the sheet.
Object Properties - Displays, in a non-editable form, the properties of the object currently selected in the Model Node Browser or Sheet.
Table Entity Node - Contains a tree of the Relationships, Indexes and Constraints of a table.
View Entity Node  - Contains a tree of the contents of a view not displayed on the current sheet.
Table Entity Object - Represents a table, its attributes, keys, physical schema and comments.
Note Entity Object - Text notes that are not a part of a database schema, for use in the diagram only.
Region - A grouping of entity objects and notes. Regions do not exist as schema objects and are strictly for diagram organization.
Relationship Entity Object - Represents a relationship between tables.
Subcategory Entity Object - Represents a subcategory relationship.
One to Many Relationship Entity Object - Palette icon for creating a One to Many Relationship.
One to Many (NI) Non-Identifying Relationship Entity Object - Palette icon for creating a One to Many Non-Identifying relationship.
Relationship Cardinality: Zero or More, Zero or One, One or More, Exactly n - Options for setting the cardinality of a relationship, which determine the relationship connector’s endpoints in the diagram.
New Unique Constraint - available on right click on a table within a sheet, or right click in the Model Node Browser.
New Index - available on right click on a table within a sheet, or right click in the Model Node Browser.
 
 

 

 

 

Requirements

1. Update to latest library/build
2. Work with SQL Server 2000 - Northwind
3. Graph relationships:
   a. Relationship name and Icon in the center of the relationship
   b. Relationship column names on the tips
4. Primary Key and Index icons, see if we can put to the left side of column names in Graph
5. Look for option to disable "Auto-Layout" for performance
6. Ability to manually create Relationships and Graphs. [Define columns, constraints and indexes for Graph]
7. Ability to save and open ER Diagrams.
8. Ability to print ER Diagram.
9. Ability to save as Image.
10. Ability to generate script from ER Diagram.

 

ER Diagram Generator Dialog

1. The Object Types and Object tables are now sortable, the Object table is filterable

2. ComboBox functionality has changed

 

Notes for QA

Test the following functionality:

1. You’re able to sort Object Type table, sort and filter Object table

2. When the table are sorted, you get the right objects selected and scripted

3. autocompletion in case when the combobox is not editable should show the item when it’s present on the list, and do nothing if it’s not present (type some garbage to check that)

4. autocompletion in case when the combobox is editable should show the item no matter if it’s present on the list

5. backspace <- should remove the item if the combobox is editable and do nothing if it’s not

 

 

Entity Relationship Diagram Frame

dockable sub-panels:

palette

model

object properties

graph properties

bird’s eye view (overview)

 

Last updated by swissarmyknife(*) on May 15, 2008 10:19 PM

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017