I projecting distributed database. I did RMBD but i have doubt. If product is in shop in which we arecurrently - no problem ( seller click "sell" ) but if product is in shop about name "Shop 5" ( e.g in London ) seller click "Order" and application sends information about order for "Shop A". Is good idea create new table WatingOrders for every shop?
Between table Products and Stores is relation many - many - It is okay. Now, Clients may have many Orders and one order may have one list products, but one list products may have many Products ( foregin key with table Products_Stores ) it is okay?