-
Notifications
You must be signed in to change notification settings - Fork 14
Supported ER Concepts
Philipp edited this page Jan 24, 2023
·
5 revisions
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.
Usage
Development