"Relating" Relations
As noted: there is no direct analog of the E/R "relationship" (diamond shape)
Possible solution: foreign key in one of the relations
Common solution: A "relationship relation"
- attributes are the keys of the two relations
- tuples stand for pairs of related entities
- As in E/R, the two entity sets may be the same