title: Compund field database design
body: <p>I need help on the best way to design a database/tables for the following data.</p>
  
  <p><strong>I have a supplier</strong> : Supplies various products for a Project.</p>
  
  <p>For each product they supply. the rate changes depending on the day of the week, the time of day and if it is a public holiday or a weekend.</p>
  
  <p>Any Ideas???</p>
  
  <p>Example:</p>
  
  <pre><code>                    Week Day Rates        | Saturday/Sunday &amp; Public Holiday Rates                  
  Start Time  0:00    3:00    6:00    17:00 | 0:00    3:00    6:00    17:00   20:00   
  End Time    3:00    6:00    17:00   20:00 | 3:00    6:00    17:00   20:00   23:59
  
  Product 1   1.00    2.00    3.00    4.00  | 6.00    7.00    8.00    9.00    10.00   
  Product 2   5.00    8.00    8.00    9.00  | 2.00    6.00    7.00    8.00    9.00    
  Product 3   3.00    2.00    3.00    5.00  | 3.00    4.00    5.00    8.00    10.00   
  </code></pre>