I have a detailed listing of personality test questionnaires, which depending on the answer that user has chosen, he will skip adhoc to a distant question far behind in the questionnaire. All in all, he will answer only 24 questions out of 900, which means programmer needs to enable him to skip to the right question depending on the answer he has picked. This is a system of 5 Multiple-Choice answers to each question, for him to choose.
Note, however, after answering 4 questions each time, he will be assigned 2 letters of the alphabet, and you are to store this in one row in the database according to the user's id.
So, 6 sets of 4 questions (since 6*4=24 questions), and he will be assigned 2 letters of the alphabet 6 times. Store these 6 pairs of alphabetical letters in one row in the database. The next user id will have corresponding next row of 6 pairs of alphabetical letters, corresponding to each set.
Also, I want the user's answers picked and the question number that he was directed to answer (out of this list of 900 questions) stored in a separate table or database. The best is 1 row of 24 columns indicating values for the question number in one table, and 1 row of 24 columns indicating values for the MCQ answer he has chosen.
Then only the next member id will be the next row on each table.
So, got it? So, this will be a members' site, for many members to attempt 24 questions, and have their answers and question number stored , as well as the 6 pairs of alphabetical letters.
So, all in all, 3 tables only required. But different rows or observations will corresponding with the next member and so on, as this is a multi-member site.
Expect no mistakes, as I am a busy person and am hardpressed for time to pinpoint errors to programmer. Programmer expected to be independent, highly accurate in your coding, as I am very busy.