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
books. 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
i2 in one map, and three segments
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
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?