While designing a database I was stuck like how does ecommerce platforms like Amazon set their prices in advance for festive seasons and for specific sales.
Generally we can set the price of a product in the products table if we are speaking of a simple design. But how can we set the prices in advance for a sale in advance? How can this be implemented?
Any solution to achieve is welcome, the solution can be simple or complex.