I am designing database for a question and answer projects , and I am stuck. I do not know how to do it.
Here is information:
- There will be many users
- There will be many questions
- Each question has 3 options (answers) and user chooses one.
- Each question has 3 time constraints to answer. (Time constraints will change as questions.)
- Each time constraint has different point. (Also points will change as questions.) (For example, question 1 has 3, 10 , 40 seconds time constraints. If user answers in 3 seconds, he/she will take 30 points. If users answers in 10 seconds, he/she will take 10 points etc.)
- Only one answer is correct, other 2 are wrong.
- There will be score table for users.
- User will answer once a question.
My current design can be seen here: https://s32.postimg.org/lolr4vqvp/Screen_Shot_2016_06_29_at_17_14_01.png
I want to manage everything with Core data after I want to collect all data in sqlite database. Could you help me to create database design?