I know in some many-to-many relationships, an entity is related to other entities on an individual basis. But is this always the case?
For example, in the Authorship
relationship between author
s and book
s. An author can write many books, and a book can have many authors. In each such connection, an author is individually connected to the book he/she authors, and vice versa, a book is individually connected to its authors.
However, in some cases, a group of things relate to another group of things. The relationship seems to be between the groups of entities rather than individual entities.
For example in the picture below, one road is drawn as two segments i1
i2
in one map, and three segments j1
, j2
, j3
in the other map. In a sense, the two groups of segments form a one-to-one correspondence.
But does this situation constitutes a many-to-many correspondence in relational database theory?
If yes, this is weird, because unlike the authorship relationship, i1
seems to have nothing to do with j3
individually.
If not a many-to-many relationship, what is this kind of correspondence in relational database theory called? And how do we translate this to physical table design?