title: Sql database query/structure
body: <p><img src="https://i.stack.imgur.com/C60iU.png" alt="enter image description here"></p>
  
  <p>In the situation pictured below/above.
  I want to be able to query, what musicians are on a song and which songs a musician is on...</p>
  
  <ol>
  <li>is this the correct model for this situation?</li>
  <li>Do I just query the "SongMusicians" Table?</li>
  </ol>
  
  <p>This is an assignment for university and am having trouble with the theory.</p>
  
  <p>My initial thought was to just have the songId in the musician Table and visa versa. BUT have been told i need a "intermediary" table. </p>
  
  <p>Any help would be amazing</p>
  
  <p>Thanks</p>