title: How to normalize these tables to 3NF
body: <p>As part of a homework assignment I have been asked to create tables based on a case study, and all tables must be in 3NF. However, I've tried and tried to understand 3NF but I'm just not getting the hang of it and would appreciate some help.</p>
  
  <p>The requirements of the case study are for a vet clinic:</p>
  
  <ol>
  <li>Allow pets to be booked in for appointments </li>
  <li>Record pet treatments </li>
  <li>Record which vet performed the treatment </li>
  <li>Record items sold by the business to provide info that allows the business to produce sstock lists for purchase from the suppliers</li>
  </ol>
  
  <p>DOESNT NEED TO: RECORD ALL SALES</p>
  
  <p>I have the following tables so far:</p>
  
  <p>staff:</p>
  
  <pre><code>| staff_ID | firstName | lastName | gender | address_ID | contactNumber | partTimeOrFullTime | salary |
  </code></pre>
  
  <p>A staff address table:</p>
  
  <pre><code>| address_ID | staff_ID | number | street | city | county | postalCode | 
  </code></pre>
  
  <p>The vet table:</p>
  
  <pre><code>| staff_ID | appointment_ID |
  </code></pre>
  
  <p>vet_nurse: </p>
  
  <pre><code>| staff_ID | appointment_ID |
  </code></pre>
  
  <p>An appointment table:</p>
  
  <pre><code>| appointment_ID | customer_ID | staff_ID | patient_ID | date | time |
  </code></pre>
  
  <p>initial_appointment table:</p>
  
  <pre><code>| appointment_ID | customer_ID | patient_ID | diagnosis | treatment |
  </code></pre>
  
  <p>followUp_appointment:</p>
  
  <pre><code>| appointment_ID | customer_ID | patient_ID | diagnosis | treatment |
  </code></pre>
  
  <p>patient:</p>
  
  <pre><code>| patient_ID | customer_ID | animal_type | gender | weight | height | previous_Appointments | previous_Treatment |
  </code></pre>
  
  <p>product:</p>
  
  <pre><code>| product_ID | name | product_Category | animal | price | quantity_Available | reOrder_Level |
  </code></pre>
  
  <p>product_sold:</p>
  
  <pre><code>| sale_ID | product_ID | sale_Date | 
  </code></pre>
  
  <p>supplier:</p>
  
  <pre><code>| supplier_ID | product_ID | contactNumber | email |
  </code></pre>
  
  <p>suppliers_address:</p>
  
  <pre><code>| supplierAddress_ID | supplier_ID | doorNumber | street | city | town | postalCode |
  </code></pre>
  
  <p>inventory:</p>
  
  <pre><code>| name | product_ID | quantity_Available | price |
  </code></pre>
  
  <p>Thanks!</p>