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
EntityEntity
Weak EntityWeak Entity
RelationshipRelationship
Identify RelationshipIdentifying Relationship
AttributeAttribute
key attributeKey Attribute
Multivalued AttributeMultivalued Attribute
composite AttributeComposite Attribute
Derived AttributeDerived Attribute
Total ParticipationTotal participation of E2 in R
CardinalityCardinality Ratio 1:N

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

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