title: Inventory Promotions/Discount Table Structure
body: <p>I am developing an inventory system and I need help designing a product (items) table, per the below requirements.</p>
  
  <ol>
  <li>Some items Have Promotions, like take two items and get one free.</li>
  <li>The company gives a 2% discount above $100 sale for a single bill.</li>
  <li>Promotions: if someone purchases 10 packs, the company gives 1 pack, including some units. Also, say if someone purchased 10 cartons of cigarettes (containing 10 boxes of cigarettes) then the company gives 1 carton and 5 boxes of cigarettes free. </li>
  </ol>
  
  <p>My question is how can I handle this? Should I create separate tables for all these types of promotion, or in same table I can handle all of them? </p>