I have a question on Entity Relationship design.
It is a shop where products are kept in stock first and then go to the store. When the store has less than a certain amount of product, products that are in stock go to the store. How would you design these entities?
I thought two entities
products_stock but I don't know if there is another, more practical way.