title: Translating relationship attributes from ER diagram into SQL
body: <p>Currently trying to get to grips with SQL for the first time, so I am working through a few problems. Here is a sample database spec:</p>
  
  <blockquote>
    <p>Students (name, gender, course) do projects(title). Each project has
    two supervisors (name, gender, department). All students do a project
    but not all projects get taken. More than one student can do the same
    project. Students meet one of their supervisors regular and these
    meetings are recorded (date, time, student, supervisor, notes).</p>
  </blockquote>
  
  <p>So far I've got an ER diagram drawn up which I think is correct:</p>
  
  <p><img src="https://i.stack.imgur.com/i5hmk.png" alt="enter image description here"></p>
  
  <p>I can get the basics (e.g. creating a Student table etc) but I'm having trouble getting my head around how to represent the relationships, specifically the meetings relationship, and how to represent it and its attributes in SQL. Should I instead create a 'meetings' entity?</p>