I don't think this is possible in Dbman SQL -- or not easily, but maybe somebody here could confirm it?
Create many-to-many relationships, eg
Author n<==>n Book
where ...
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.
Create many-to-many relationships, eg
Code:
Category n<==>n Book Author n<==>n Book
where ...
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.