title: Identifying unf, 1nf, 2nf, 3nf in Database Normalization
body: <blockquote>
    <p>... instructor. The UNF relation has been provided.</p>
  </blockquote>
  
  <pre class="lang-none prettyprint-override"><code>                             Premiere Corporation
                               Order Detail Report
  +-------+----------------+-----+---------+------+--------------+-----+--------+
  | Order |    Order       | Cust| Cust    | Part | Part         | Qty | Quoted |
  | Number|    Date        | Num | Last Nam|Number| Desc.        | Ord | Price  |
  +-------+----------------+-----+---------+------+--------------+-----+--------+
  | 12489 | 2016-09-02 124 | 124 | Adams   | AX12 | Iron         |  11 | 14.95  |
  +-------+----------------+-----+---------+------+--------------+-----+--------+
  | 12491 | 2016-09-02 311 | 311 | Charles | BT04 | Gas Grill    |  3  | 440.00 |
  |       |                |     |         | BZ66 | Washer       |  1  | 399.99 |
  |       |                |     |         | CX11 | Mini Blender |  1  | 11.98  |
  +-------+----------------+-----+---------+------+--------------+-----+--------+
  | 12494 | 2016-09-04     | 315 | Daniels | CB03 | Bike         |  4  | 279.96 |
  +-------+----------------+-----+---------+------+--------------+-----+--------+
  | 12495 | 2016-09-04     | 256 | Samuels | CX11 | Mini Blender |  2  | 23.96  |
  +-------+----------------+-----+---------+------+--------------+-----+--------+
  | 12498 | 2016-09-05     | 522 | Nelson  | AZ52 | Dartboard    |  2  | 12.96  |
  |       |                |     |         | BA74 | Basketball   |  4  | 24.96  |
  +-------+----------------+-----+---------+------+--------------+-----+--------+
  | 12500 | 2016-09-05     | 124 | Adams   | BT04 | Gas Grill    |  1  | 149.99 |
  +-------+----------------+-----+---------+------+--------------+-----+--------+
  | 12504 | 2016-09-05     | 522 | Nelson  | CZ81 | Treadmill    |  2  | 325.98 |
  +-------+----------------+-----+---------+------+--------------+-----+--------+
  </code></pre>
  
  <h3>UNF</h3>
  
  <p>ORDER [<strong><code>OrderNo</code></strong>, Orderdate, CustNo, CustLname, (PartNo, PartDesc, QtyOrd, Price)]</p>
  
  <h3>1NF</h3>
  
  <p>ORDER [<strong><code>OrderNo, PartNo</code></strong>, Orderdate, CustNo, CustLname, PartDesc, QtyOrd, Price]</p>
  
  <h3>2NF</h3>
  
  <p>ORDER [<strong><code>OrderNo</code></strong>, Orderdate, CustNo, CustLname, QtyOrd, Price]</p>
  
  <p>PART [<strong><code>PartNo</code></strong>, PartDesc]</p>
  
  <p>ORDER_PART [<strong><code>OrderNo (FK), PartNo (FK)</code></strong>]</p>
  
  <h3>3NF</h3>
  
  <p>ORDER [<strong><code>OrderNo</code></strong>, Orderdate, <strong><code>CustNo (FK)</code></strong>,  QtyOrd, Price]</p>
  
  <p>CUSTOMER [<strong><code>CustNo</code></strong>, CustLname]</p>
  
  <p>PART [<strong><code>PartNo</code></strong>, PartDesc]</p>
  
  <p>ORDER_PART [<strong><code>OrderNo (FK), PartNo (FK)</code></strong>]</p>
  
  <hr>
  
  <p>I need to normalize data into unf to 3nf. Though, i am not sure what i have done is correct.</p>