title: SQL Fact table-dimension
body: <p><a href="https://i.stack.imgur.com/58kdU.png" rel="nofollow noreferrer"><strong>LARGE RESOLUTION (click here)</strong></a></p>
  
  <p><img src="https://i.stack.imgur.com/58kdU.png" alt="enter image description here"></p>
  
  <p>How can we put to the fact table called Patent a foreign key for the primary key of the Inventor table (InventorID) preserving the right connection of the tables as noted by the relation between the primary key of the table Patent called Patent and its foreign key Patent of the table Inventor.
  We are doing this to create a dimension using the inventor table for the fact table patent.</p>