title: Mapping between weak and strong entity
body: <p><a href="https://i.stack.imgur.com/QtKKh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QtKKh.png" alt="enter image description here"></a>Consider the er diagram. </p>
  
  <p>Q1:</p>
  
  <p>The dependants table will have a serial number column as a surrogate key for the sake of uniqueness of rows in this table. But we are not including this surrogate key column as an attribute in er diagram since its not an attribute of dependants. Right?
  YES or NO?</p>
  
  <p>Q2:</p>
  
  <p>Okay now my second question is that in order to uniquely identify that which dependant is owned by which employee, we will use a combination of Employee SSN and Dependants Name. Pretty good. But my confusion here is that how are we gonna find that out? I mean we are not storing any kind of dependants info in employee table and i know that doing so is illogical. but how to find that which dependant belongs to which employee? If possible, please write down a sql query regarding this so my confusion regarding this clears out.</p>
  
  <p>Q3:</p>
  
  <p>In dependants table, primary key would be serial Number but for searching that which dependant belongs to which employee, we will use a unique combination of employee id and dependant name.</p>
  
  <p>I pretty confuse at all of this. I do know what weak and strong entities are and that they have identifying relationship between them but i am pretty clueless at above questions. And please answer questions by numbering them to their respective question number. Thanks:)</p>