title: Weak Entity containing a foreign key as a primary key
body: <p>I have created a table called <code>STUDENT</code> which consists of Unique ID as the PRIMARY KEY along with other related attributes like <code>Name</code>, <code>Addr</code>, <code>Gender</code> etc....</p>
  
  <p>Since I don't want to increase the table size of the <code>STUDENT</code>, I created a weak entity called <code>ACADEMIC RECORDS</code> which stores the previous Academic Records of the student.But in this table i have only created a PRIMARY KEY <code>Unique ID</code> which references the <code>Unique ID</code> of the student. and there is no other attribute in conjunction with <code>Unique ID</code> in the weak entity <code>ACADEMIC RECORD</code> Table.</p>
  
  <p>As I came across the definition OF A WEAK ENTITY which define its primary key as a combination of weak entity's attribute and the owner's table's primary key(in this case <code>STUDENT</code>)</p>
  
  <p>Is my method of creating a foreign key as the only primary key in the table <code>ACADEMIC RECORD</code> correct??</p>
  
  <pre><code>STUDENT Table  
  **UID**  NAME  GENDER  ADDRESS  PHNO.
  
  ACADEMIC RECORD Table  
  **UID**  HighschoolMarks  GradSchoolMarks
  </code></pre>