I am trying to design a database schema for the following entities: Stores, Products, Discounts and Buyers. The goal is to provide a discount campaign for a couple of products. However, on my first iteration over the database schema I can see there is a circular dependency as illustrated bellow:

[![enter image description here](https://i.stack.imgur.com/GT1lK.png)](https://i.stack.imgur.com/GT1lK.png)

The question is: Is having such dependencies a bad SQL Design ? Also, how can I include the entity of Buyer that will represent reference the product and the discount used ?Thank you.