Login logout

ER-Designer with the Entity Context menu. From the tool bars, data dictionary, and context menus, many aspects of U/I are coordinated for a smooth Drag and Drop system of data base schema creation.
Figure 1

Drag and Drop Diagram Construction

ER-Designer enables the fast, efficient, and fluid creation of Entity Relationship diagrams (e.g. data models) through a drag and drop paradigm. The screen snap shot in Figure 1 shows some of the key features that make this possible.

Entities (tables) can be created by clicking on the "New Entity" in the toolbar on the left, then clicking repeatedly on the diagram. Each click will create a new entity with a (not to imaginative) unique name (you may want to change the name :).

The left side pane displays the Data Dictionary. You can click on a domain in the Data Dictionary and drop it onto one of the entities. The will create an attribute (aka a column) in the Entity.

Then you can right click on the Entity and give it a reasonable name. With a second right click you can enter a description. And a third will set the entity's background color.

You can add relationships (Identifying, non-identifying mandatory, or optional, and non-specific) by clicking on the appropriate New Relationship icon in the toolbar, and clicking on a parent then a child entity.

As you can see, with a reasonable Data Dictionary (the Data Dictionaries can be exported from a diagram and imported into a new diagram) you can create a reasonable data model and never even invoke an Entity, View, Column, or Relationship editor.

View creation follows the same paradigm as Entity creation. View "relationships" (I use this term loosely) can be connected from Entities to the View. The View editor is brought up to assign alias to the View Columns, and build the where clause for the view.