I have a randomly generated question from 4 different question tables. Here is want I want:
1. I want to make the generated question available for the users so that they can answer the question.
2. As they work on each questions, I want to compair the users answer with the stored correct answer
3. According to the user answer, for each question I want to calculate the mark/weight of each question, add the total grade and store the total in the Grade Table according to their ID/Name.
E.g User 1: Total grade 89 out of 100
user 2: Total grade 100 out of 100
4. Also, I want to make all the above activity applied for every randomly generated question.
Information: At a time, a minimum of 10 question can be generated. So that means, for a one time generated question, the user will be asked to work on 10 questions.
Is it possible to implement the above with out storing the generated questions back in another table and retrive them back and allow user to work on the question? If yes how? If not how do you think it will be possible?
I greatly appreciate your help
Thank you in advance.