Relationship
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
A relationship refers to the association between two entities in an ERD. Each end of the relationship shows the degree of how the entities are related and the optionality.
The degree can be expressed as:
- 1:1 - One-to-One relationship in an ERD
- 1:N - One-to-many relationship in an ERD
- N:N - Many-to-many relationship in an ERD
For example: An employee can belong to one and only one department, but a department can have many employees (1:N).
Also see
- ARC relationship - indicate mutually exclusive relationships
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
