Entity-Relationship Diagram
Last updated
Last updated
To create a Entity-Relationship Diagram:
Select first an element where a new Entity-Relationship Diagram to be contained as a child.
Select Model | Add Diagram | ER Diagram in Menu Bar or select Add Diagram | ER Diagram in Context Menu.
To create a Data Model (model element only) by Menu:
Select an Element where a new Data Model to be contained.
Select Model | Add | Data Model in Menu Bar or Add | Data Model in Context Menu.
To create an Entity:
Select Entity in Toolbox.
Drag on the diagram as the size of Entity.
To create a Entity (model element only) by Menu:
Select a Data Model where a new Entity to be contained.
Select Model | Add | Entity in Menu Bar or Add | Entity in Context Menu.
You can use QuickEdit for Entity by double-click or press Enter on a selected Entity.
Name : Enter name.
Add Note : Add a linked note.
Add Column (Ctrl+Enter) : Add a column.
Add One to One : Add an one-to-one relationship with an entity.
Add One to Many : Add an one-to-many relationship with an entity.
Add Many to Many : Add an many-to-many relationship with an entity.
To suppress Columns, see Suppress Columns.
To add a Column:
Select an Entity.
Select Model | Add | Column in Menu Bar or Add | Column in Context Menu.
You can use QuickEdit for Column by double-click or press Enter on a selected Column.
Column Expression : Edit column expression.
Syntax of Column Expression
Primary Key : Check whether the column is primary key or not.
Add (Ctrl+Enter) : Add one more column in the below.
Delete (Ctrl+Delete) : Delete the column
Move Up (Ctrl+Up) : Move the column up.
Move Down (Ctrl+Down) : Move the column down.
To create a Relationship:
Select One-to-One Relationship, One-to-Many Relationship or Many-to-Many Relationship in Toolbox.
Drag from an entity and drop on another entity.
You can use QuickEdit for Relationship by double-click or press Enter on a selected Relationship.
Name : Enter name.
Identifying : Check whether the relationship is identifying or not.
Add Note : Add a linked note.
You can also use QuickEdit for Relationship End by double-click at the end side of a Relationship.
Name : Enter name.
Cardinality : Select cardinality of the selected relationship end.
