title: In ERD modeling Does A Relation Map To A Database Table
body: <p>The following is an Entity Relationship of a a Baseball League.  <img src="https://i.stack.imgur.com/VY1z0.png" alt="enter image description here" /></p>
  <p><em><strong>I'm having a bit of confusion understanding Relations and Attributes of Relations.</strong></em></p>
  <p>An description of the diagram follows:</p>
  <p><img src="https://i.stack.imgur.com/BNVwO.png" alt="enter image description here" /></p>
  <p>According to the description, Participates is a Relation and Performance is an Attribute (complex) of Participates.</p>
  <p><strong>Questions</strong>:</p>
  <ol>
  <li><p>How do Participates Map to actual tables in a database?</p>
  </li>
  <li><p>Would there be a Participates table with the fields that define Performance?</p>
  <p>{Hitting(AtBat#, Inning#, HitType, Runs, RunsBattedIn,
  StolenBases)}, {Pitching(Inning#, Hits, Runs, EarnedRuns, StrikeOuts, Walks, Outs, Balks, WildPitches)}, {Defense(Inning{FieldingRecord(Position,
  PutOuts, Assists, Errors)})}</p>
  </li>
  <li><p>Similarly are Plays_For, Away_Team and Home_Team also tables.</p>
  </li>
  <li><p>As you create tables in a database (say MySql) how are Relations differentiated from Entities / Objects like Player, Team and Game.</p>
  </li>
  </ol>
  <p>Thanks for your help.</p>