title: maintaining a price table changes every day
body: <blockquote>
    <p>state     (st_id,st_name)<br>
    district   (d_id,d_name,st_id[FK])<br>
    product    (pid,pnme)<br>
    price      (max_price,min_price,pid[FK],d_id[FK])</p>
  </blockquote>
  
  <p><img src="https://i.stack.imgur.com/JRsAH.png" alt="enter image description here"></p>
  
  <p>1.)This is my table structure, i want to show the  price of  products in  5 states and its districts,but in price tbl i'm repeating the product(more than 10) for each district.</p>
  
  <p>Whats wrong with my price tbl, Could you plz give an idea to  normalize it..</p>
  
  <p>2.) NOw i'm just planning to add date stamp(start date) field to  price tbl so that i can maintain historical price list, but how can i do it without repeating product(like shown below) on each date..any better solution to reduce the tbl rows</p>
  
  <pre><code>_______________________________________
  product| price |district|date(mm/dd/yy)| 
  _______|_______|________|______________|
  fan      200   delhi    3/15/2013
  speaker  400   delhi    3/15/2013
  fan      210   chenni   3/15/2013
  speaker  403   chenni   3/15/2013
  fan      200   delhi    3/16/2013
  fan      210   chenni   3/16/2013
  </code></pre>