Please enable JavaScript.
Coggle requires JavaScript to display documents.
Concept of Relationships in ER Diagram, Maximum number of relationship…
Concept of Relationships in ER Diagram
Relationship
Unary Relationship
Binary Relationship
Ternary Relationship
Relationship Constraint
Cardinality Ratio
1:1
1:N
N:1
M:N
Participation Constraints
Total Participation
Partial Participation
Attributes of Relationship Types
In 1:1 or 1:N relationship types, attributes can be migrated to one of the participating entity types
1:1 : Can be migrated to either entity types
1:N or N:1 : Can only be migrated to the N entity type side of relationship
In M:N relationship types, SOME attributes can be determined by a combination of participating entities
Role Name
Recursive Relationship
Alternative Notations
Generalization
Specialization
Maximum number of relationship instances that an entity can participate in.
Specifies whether existence of an entity depends on its being related to another entity
Signifies the role that a participating entity plays in each relationship instance