Entity-Relationship Diagram
![](https://docs.staruml.io/~gitbook/image?url=https%3A%2F%2F355876146-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FKTZm1QYaBWRoj7YYScQh%252Fuploads%252FwnKxssLqY0m9dZzJskTU%252FMain.png%3Falt%3Dmedia%26token%3D0814e1f3-0295-4026-95d0-6912d91fd77c&width=768&dpr=4&quality=100&sign=e1067f9&sv=1)
Create Entity-Relationship Diagram
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.
Data Model
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.
Entity
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.
Column
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 columnMove Up (
Ctrl+Up
) : Move the column up.Move Down (
Ctrl+Down
) : Move the column down.
Relationship
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.
Last updated