Supported ER Concepts - borkdominik/bigER GitHub Wiki
The table below provides an overview of the supported ER concepts in bigER.
✅ - Supported
⏺ - Partly supported
❌ - Not supported
| ER Concept | Textual | Graphical | Generator | Additional information |
|---|---|---|---|---|
| Entities | ||||
| Strong Entity | ✅ | ✅ | ✅ | |
| Weak Entity | ✅ | ✅ | ❌ | |
| Relationships | ||||
| Binary Relationship | ✅ | ✅ | ✅ | A -> B |
| Unary Relationship | ✅ | ✅ | ✅ | A -> A |
| Ternary Relationship | ✅ | ✅ | ✅ | A -> B -> C |
| N-ary Relationship | ❌ | ❌ | ❌ | up to ternary (3-ary) supported |
| Cardinality Constraints | ✅ | ✅ | ❌ |
1 (one) or N (many) e.g. A[1] -> B[N] (one-to-many) |
| Participation Constraints | ✅ | ✅ | ❌ |
0 (zero/optional) or 1 (one/mandatory) e.g. A[0..1] (zero-or-one) |
| Roles | ✅ | ✅ | ❌ | A[ N | "role" ] |
| Attributes | ||||
| Entity Attributes | ✅ | ✅ | ✅ | |
| Relationship Attributes | ✅ | ⏺ | ✅ | visible only on hover (diagram) |
| Keys | ✅ | ✅ | ✅ |
attr key (primary key) attr partial-key (for weak entities) |
| Datatypes | ✅ | ✅ | ✅ |
attr1: INTEGER or attr2: VARCHAR(50)
|
| Composite Attribute | ❌ | ❌ | ❌ | |
| Multi-valued Attribute | ✅ | ✅ | ❌ | attr multi-valued |
| Derived Attribute | ✅ | ✅ | ✅ | attr derived |
| EER Concepts | ||||
| Generalization | ✅ | ✅ | ❌ | A extends B |
For more information on how to use the concepts, see the Language Documentation.