title: Understanding an ER Diagram
body: <p>I am new to creating tables from a given ER diagram and while I have worked with crow's foot diagram, I am completely new to the type of diagram below.</p>
  
  <p><strong>From this, how do I determine the primary, foreign keys in the tables and 1-1, 1-many etc. relationships?</strong></p>
  
  <p><a href="https://i.stack.imgur.com/80O9o.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/80O9o.png" alt="ER model"></a></p>
  
  <p>Thanks a lot for any suggestion.</p>
  
  <p><strong><em>P.S.</em></strong> I am trying to model it in MySQL Workbench, so if there are any specific suggestions, I will be obliged!</p>