Hey there, im currently trying to creat a database for at quiz system, and i dont really know how i should do this.
Lets start with the basics, there should be a array of different quiz types for example (Classic, Guess the number and Match quiz) and this should have a Category too.
This part seems pretty straight foward to me, here i would just create at table for each (Quiz, Category and Type), but now i need to add questions and answers to each quiz, and this is where im getting a little confused, because all the different types of quizzes should have a different layout and im not sure how to do this the best way.
Is there a nice and compact way to do this or do i have to create 2 tables for each quiz type?
Does this make sence or should i describe it in another way?