title: Entity relation
body: <p>Is the following entity relation correct? I am trying to link employee, timesheet and approver table. </p>
  
  <p>There are few other tables and fields but for this question my main concern is following three tables. One employee can have more than timesheet approver.</p>
  
  <pre><code>Employee
  --------
  EmpID pk
  Name
  </code></pre>
  
  
  
  <pre><code>TimeSheet
  ------------
  TSHEET_ID PK
  FK_EmpID FK
  Approved_By
  </code></pre>
  
  
  
  <pre><code>Timesheet_Approver (one employee can have more than one approver
                      but only one will be approving the timesheet)
  ------------------
  EmpID
  Approver_EmpID 
  </code></pre>
  
  <p>Employee Table Data:</p>
  
  <pre><code>EmpID Name
  ----- -----
  1     john
  2     david
  3     mark
  </code></pre>
  
  <p>Timesheet Approver Data:</p>
  
  <pre><code>EmpID Approver
  ----- --------
  1     2
  1     3
  2     3
  </code></pre>
  
  <p>Timesheet </p>
  
  <pre><code>TSID EMPID APPROVED_BY
  ---- ----- -----------
  101  1     2
  102  1     3
  103  2     3
  </code></pre>
  
  <p><br><br>
  <strong>OR this looks okay?</strong>
  <br></p>
  
  <p><img src="https://i.stack.imgur.com/PlSKG.jpg" alt="enter image description here"></p>