title: Finding primary key given relation and functional dependencies
body: <p>Given the relation:</p>
  
  <p>Competitor(PID, EventName, Pname, TeamName, TeamCoach,
  EventDate, TeamRating)</p>
  
  <p>And the functional dependencies:</p>
  
  <pre><code>PID -&gt; Pname, TeamName, TeamCoach 
  TeamName -&gt; TeamCoach 
  EventName -&gt; EventDate 
  TeamName, EventName -&gt; TeamRating 
  </code></pre>
  
  <p>Based on my knowledge I believe the primary key is {PID, EventName, TeamName}</p>
  
  <p>The answer provided says that the primary key is {PID, EventName}</p>
  
  <p>Either I am wrong (which is likely) or the answer provided is wrong.</p>
  
  <p>If you could tell me which is right and the method of how you found it, that would be great.</p>