Thanks David. I was able to figure out.

I have a survey table where people were asked up 7 question and I'm trying to figure out the best way to assign a primary key in sql. here how it looks like. key surveyid questionid answid questions answer ed45894 1 3 1 when was the last time you bought soda 1 week ago ed45894 1 7 2 How many live in your house 4 ed45894 1 4 5 do you children in your house Yes ed45894 1 2 7 do you use coupon while shopping No fs45895 1 3 4 when was the last time you bought soda yesterday fs45895 1 7 2 How many live in your house 1 fs45895 1 4 5 do you children in your house Yes fs45895 1 2 7 do you use coupon while shopping No