ER Symbols

ER Symbols

ER Symbols

  • ER model stands for an Entity-Relationship model.
  • It is a high-level data model.
  • The ER model defines the conceptual view of a database.
  • It works around real-world entities and the associations among them.
SymbolsDescription
Entity
Weak Entity
Relationship
Identifying Relationship
Attribute
Key Attribute
Multivalued Attribute
Composite Attribute
Derived Attribute
Total participation of E2 in R
Cardinality Ratio 1:N

1E1 entity can be related to NE2 entity
Structural Constraint (Min, Max) on participation of E in R
Optional One
Optional Many
Mandatory One
ER Symbols
Leave a Reply 0

Your email address will not be published. Required fields are marked *


Exit mobile version