when we design Entity sets during database designs through Entity Relationship Diagram, there have to be some kind of connections existing between them too. These connections are called “Relationships “derived from the real world term. A relationship can be classified according to the degree or connectivity. The following are the important points to remember about relationships in Entity Relationship diagrams
- A relationship is an association between entity sets.
- The entity sets that are involved in the relationship are also known as participants.
- Relationships are named and the name is generally a verb.
- Relationships are always two ways i.e. they operate in both the directions, so the N: 1 between Students and Teachers could also be thought of as a 1: N between Teachers and Students.