DB structure - Managing a collection of books

[Simon Schelling]

Hi! I'm new to MySQL (and any other DB systems).
I'm trying to create a website that lists book titles. OK that's fairly easy...
Registered users should then be able to select a book and add it to either their personal collection or to their wish list.

If I have a table for the book titles (ID, auther, title, year etc.), and another table for users (ID, username, password etc.).
How do I then store the collections (personal collection and Wish list), what more tables do I need? Should I also create a seperate table for the authors.

I guess this is very basic database knowledge, yet I hope someone is able to explain this specific problem to me!

Cheers, S.



Edited 1 time(s). Last edit at 11/21/2011 04:27PM by Simon Schelling.