 <p>I have one suggestion for the database design.</p> <p>i have made a few modification in Response Table and Create a new Table.</p> <ul> <li>USER Table (User_ID [PK],USER_NAME,another Extra fields)</li> <li>TEST Table (Test_ID [PK],some other fields for test details)</li> <li>Quest_Set Table (Set_ID ,Que_ID,Question,some other fields if required)</li> <li>RESPONSE Table (Res_id ,User_ID [FK],Test_ID [FK], Set_ID , Que_ID, Ans_1 , Ans_2 , Flag)</li> </ul> <p>Please review it and let me know if you have any confusions.</p> <p>Regards.</p> <p>Please look the New_Response Table </p> <p>(Response_id, user_id, test_id,Trans_id,Ans1,Ans2,Flag)</p>