Am creating an online examination website. I need to store the answers answered by the participants who are given a unique ID. So I will be storing ID, Answers for the question, score. So I think I have two ways to do it.
- Create a table for every student with columns QuestionID, Answer, Score (When 1000 participants participate what can I do here?)
- Create a table with ParticipantID, Question1, Score1, Question2, Score2,...... (Too many columns when questions count is around 200)
Which is the optimal way of creating the table for above scenario. Since I can understand well that MySQL can have 1000s of tables. But only limited columns.