title: Database Normalization using composite key?
body: <p>Hi I have been thinking for hours about a database normalization problem that I am trying to solve. In my problem I have a composite primary key and data in one of the columns of the key has multiple values. Multiple values within one of the columns of the primary key is the major problem. I want to know whether in first normal form only repeating groups other than primary key will be removed or primary key column having multiple values will also be removed. Still may be its nebulous for you people to understand. So I am posting screenshot of the table:</p>
  
  <p><a href="http://tinypic.com/view.php?pic=ev47jr&amp;s=5" rel="nofollow">http://tinypic.com/view.php?pic=ev47jr&amp;s=5</a></p>
  
  <p>(Kindly open the image above to see the table)</p>
  
  <p>Here the question I wanna ask is that whether in first normal form only column number 4,5,6,7 will be removed or column number 2 will also be removed (Since it also contains multiple values)?</p>
  
  <p>If I don't remove 2nd column then it won't come in 1NF, but if I remove it too, then it will go to 3NF directly. Help?</p>
  
  <p>Thank you. </p>