So I want to create a test prep web app. I know there are a lot of similar ideas already in the market but I want to do it by myself.
The user will log in, choose a topic + # of questions and start a test.
So far I have:
Since a question will have 4 o 5 possible answers and these choices won’t be used in another question, i believe I don’t need to create a choice’s table. Am I right? So basically I need to understand if I need to create a table just for the choices or no.
There is also another features I want and I still don’t know how to design it:
Every time a user do another attempt in the same subject, random questions should be presented avoiding the ones already used in previous attempts.
User can choose if he wants to have the questions where he didn’t succeed showing up again in the next attempts.
I appreciate any help/tips.