Quote:
Originally Posted by eschwartz
"Nontrivial".
The issue has come up before. 
|
Replacing a "many to 1" relationship between series and books with a "many to many" relationship is not, in itself, a difficult problem; it can be done by adding a "book/series" link table into the database. But it would involve rewriting all the queries involving books and series, and every additional "join" in a query slows it down, so if (as I believe would be the case) the number of books that are in multiple series is small, the benefit of doing this is probably questionable.