Book catalogue/database
I’ve been trying for a while now, to create a book cataloging system and I keep getting stuck on how I should properly handle the recursive category/serie part, as well as how author information should be stored to be most optimized for future searching.
So far I’ve come up with this db structure, although I think I’ll change it so ISBN isn’t a key, and instead create a regular auto incrementing key/id for titles as well. That way I can have several books with the same ISBN. Reason for this, is that sometimes I like having a multi-volume collection listed with each of its volumes.
