Single line with an arrow mark in Entity Relattionship diagram

Question

What do single line with an arrow mark in ER diagram represent?

Magnanimity

Answer 1

As per Bachman Notation which you are using ,

"For every relation a rectangle has to be drawn and every coupling is illustrated by a line that connects the relations. On the edge of each line arrows indicate the cardinality. We have 1-to-n, 1-to-1 and n-to-m"

And "Cardinality use to represent the relationship between two entities."

For more on cardinality Notations

Ansermet

Where did you find this graphic? It's really helpful and somehow it's the only reference I've found for the arrow notation. – Sessions

cs.unc.edu/~stotts/145/CRC/class.html you can refer this one to know more. – Ansermet

Answer 2

E.R diagrams represent entities as boxes, and relationships as lines between the boxes. The ends of these lines are shaped to represent the cardinality of the relationship

an arrow from entity set to relationship set indicates a key constraint, i.e. injectivity: each entity of the entity set can participate in at most one relationship in the relationship set;

Have a look at these resources also for better understanding

---

Edited by user Ed Gibbs. Both links below are broken as of June 2024.

schemabank.com/help/notation-entity-relationship-diagram DANGER: this link's domain no longer belongs to the original author.

smartdraw.com/resources/tutorials/cardinality-notations/

Pound

Answer 3

the simple answer is that it means your two entities who both are part of the same relationship, one instance of them must be part of the relationship but the one who the arrow points towards can exist only once or not at all. For example a president have a head but not all presidents use them for chess. So the relationship between chess games and president should be a arrow pointing from presidents to a relationship personPlayingChess single arrow towards Chessgames.

Implacable

Answer 4

It represents at most 1 participating in the relation, so if both entities having an arrow from the relationship it will be 1 to 1 relationship and when there is a single line in both sides it will be M to M relationship.

Plea