Create many-to-many relationships, eg
Author n<==>n Book
Categories may contain many Books
Books may be assigned to more than one Category
Authors may write many Books
Books may have more than one Author
This is not a critical issue for us, but it would be very helpful to know what is possible, and what is not.