title: Many-to-many relations in RDBMS databases
body: <p>What is the best way of handling many-to-many relations in a RDBMS database like mySQL?</p>
  
  <p>Have tried using a pivot table to keep track of the relationships, but it leads to either one of the following:</p>
  
  <ul>
  <li><p>Normalization gets left behind</p></li>
  <li><p>Columns that is empty or null </p></li>
  </ul>
  
  <p>What approach have you taken in order to support many-to-many relationships?</p>