title: Finding the Primary Key and Normalising a Relation with Functional Dependencies
body: <p>I am studying for my databases exam and I've realized my professor did not teach a section of the normalization lecture notes, but glossed over them so I've been self studying and there is this example without solutions in the notes and I was wondering if I have been doing it right:</p>
  
  <p>Given Relation <code>R = {A,B,C,D,E,F,G,H,I,J}</code></p>
  
  <p>And functional dependencies:</p>
  
  <pre><code>A,B -&gt; C
  A -&gt; D,E
  B -&gt; F
  F -&gt; G,H
  D -&gt; I,J
  </code></pre>
  
  <ol>
  <li>Determine the primary key</li>
  <li>Decompose R so it is in 2NF then show it in 3NF.</li>
  </ol>
  
  <p>So, I got the primary key to be <code>(A, B, D, F)</code></p>
  
  <p>And then I tried to convert it to 2NF and I got relations:</p>
  
  <pre><code>(ABC), (DIJ), (ADE), (BF), (FGH)
  </code></pre>
  
  <p>And I honestly have no idea if this is right or how to then put it in 3NF... or if I've just skipped 2NF and already put it in 3NF. Any help?</p>