title: Translate from SQL to relational algebra
body: <p>Hey I have been asked this question:</p>
  
  <p>Translate the following SQL into relational algebra</p>
  
  <pre><code>SELECT DISTINCT Student.Name, Course.Name
  FROM Student, 
       Attendee, 
       Course
  WHERE 
          Student.Name = Attendee.Name 
     AND Attendee.CourseId = Course.CourseId 
     AND StudyCourse = ‘CS’ 
     AND Course.CourseId &gt; 42 
     AND Year = 2011
  </code></pre>
  
  <p>I've tried to look around, but i can't really seem to find a specific answer on how to do so.</p>