title: SQL Normalization UNL 1NF 2NF 3NF
body: <p>for an assignment for school, we are to draw out the UNL,1NF,2NF,3NF relations for a table we are provided. I think i was able to complete UNL,1NF,2NF but i was not sure how to do that for 3NF.</p>
  
  <p>Here is a picture of the table:</p>
  
  <p><a href="https://i.stack.imgur.com/Iv1QM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Iv1QM.png" alt="enter image description here"></a></p>
  
  <p>Here are my possible solutions missing 3NF.</p>
  
  <h2>UNF Relation</h2>
  
  <pre><code>ProductReport[ProductC, Classif, Markup(ProductID, Desc, Cost)]
  </code></pre>
  
  <h2>1NF Relation</h2>
  
  <pre><code>ProductReport[ProductC, Classif, Markup]
  
  ProductDetails [ProductC, ProductID, Desc, Cost]
  </code></pre>
  
  <h2>2NF Relation</h2>
  
  <pre><code>ProductReport[ProductC, Classif, Markup]
  Product [ProductID, Desc]
  ProductDetails [ProductC, ProductID,  Cost]
  </code></pre>
  
  <h2>3NF Relation</h2>
  
  <p>So my question is, Is my UNF,1NF,2NF correct? and if yes, how would 3NF look?</p>