I'm building an e-commerce website for a bookstore. A product (i.e. a book) has additional fields. One such field is the "author". An author can have multiple books. A book can also have multiple authors. Essentially, it's a many-to-many relationship in a relational database system.
When a user clicks on a book, it should display all of the book's authors. An individual author should have a clickable link to see other books (products) written by the same author.
Images attached for better explanation.
How can I produce this many-to-many relationship in my Shopify storefront? This seems like a very common scenario for a typical online store. I would be VERY surprised if Shopify couldn't handle the above mentioned use case.