Now I'd like to display the offers that are related to a shop on a 'front end page' specially created for this shop
You mentioned that you want to view the offers related to a shop, but from what I can understand from your model it looks like the current shop can only be linked to 1 offer. Is there a specific reason why ShopOffer is a 1 to * ? because if you do change the relation you could add a templetegrid or a list view inside the shop dataview that uses the association ShopOffer, and your offers will be visible.
hope I understood your question, and hope this helps