What would be the best way to setup a personal book library.  Would I use junction tables or have tables for author, book, series with relationships

I only want the following information:
Author:
- Name, Alias, Website, Notes

Books:
- Title, Release Date, Finished, Notes
- Novel or Series
- Book # (1 of 1 or 1 of 3)
- Total books in series (3)
- Date Read - Notes

---

Reply from Richard Rost:

I'd have BookT and AuthorT as the main tables.

You wouldn't need a junction table for these two UNLESS you want to be able to put multiple authors (many-to-many) on a single book (which does happen). For just one author, you'd need an AuthorID field in your BookT (one-to-many).

SeriesT could be another table and you'd need a SeriesID in your BookT table. Here you wouldn't need a junction table unless a book can be part of multiple series - which I don't think ever happens.

Total books in series would be a COUNT() or DCOUNT()

Date read? If you want to track when YOU read a particular book, you could just put this in your book table. If you want to track multiple people reading it, you'd need a UserT (or ReaderT) and then - you guessed it - a junction table.