title: How does an ecommerce platform like Amazon sets the price in advance for festive seasons?
body: <p>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.</p>
  <p>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?</p>
  <p>Any solution to achieve is welcome, the solution can be simple or complex.</p>