Digital content eCommerce schema advice?
Get yourself a good data model pattern book.
Accept the fact that most relationships are many-to-many.
Read up on table inheritance and the Party/Party Role model.


Some starting points:


An order has many line items, which belong to a product
A product will probably belong to multiple categories
A product will likely have more than one artist