Entity Relationship Diagram

From Open Risk Manual
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Definition

A Entity-Relationship Diagram (or E-R Diagram or Model) is a structural diagram that describes interrelated things of interest in a specific domain of knowledge. An E-R Diagram is composed of entity types (which identify the things of interest) and relationships that can exist between entities (instances of those entity types).

Entity-relationship modeling was developed for database design. It is most closely related to a Class Diagram. It does not define the Business Process it presents a business data schema in graphical form.

PlantUML Elements

A PlantUML components diagram specifies and shows the following:

  • Entities
  • Relations

Example

@startuml
skinparam handwritten true
hide circle
skinparam linetype ortho
entity "Entity01" as e01 {
* e1_id : number <<generated>>
--
* name : text
description : text
}
entity "Entity02" as e02 {
* e2_id : number <<generated>>
--
* e1_id : number <<FK>>
other_details : text
}
entity "Entity03" as e03 {
* e3_id : number <<generated>>
--
e1_id : number <<FK>>
other_details : text
}
e01 ||..o{ e02
e01 |o..o{ e03
@enduml

Entity Relationship Diagram

References