title: Database design for 3 tables with one-to-many relationship
body: <p>I have three tables  </p>
  
  <p><code>band</code><br>
  <code>member</code><br>
  <code>instrument</code>    </p>
  
  <p>Each member can be a member of several bands, but can only play one instrument in each band. I need help with designing the database for this and which relations to use.</p>
  
  <p>Any help is appreciated.</p>