title: Relational Algebra on 3 Tables
body: <p>I am having trouble forming a relational algebra query for a question in an assignment. I have to find the name of all the teams that won a game on a specific date. </p>
  
  <p>The database now has the following three schemas:</p>
  
  <pre><code>Team(teamid,teamname,stadium)
  Player(playerid,name,teamid, height)
  Game (gameid, hometeamid, guestteamid, date, home-score, guest-score)
  </code></pre>
  
  <p>I am a little confused on how to do this since the tables that I seem to need do not have anything in common (Game and Team). I see that Game has an id for both the home and away teams, but how can you find out who which team won?</p>
  
  <p>The exact question that I have to answer is:
  Find the name of all the teams that won on 6/1/15. (Assume a team plays only one game a day and that a tie is not possible)</p>