The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Jun 02, 2021 05:49 AM
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?
Jun 02, 2021 01:50 PM
I may not fully understand your dilemma, as the issue looks pretty simple to design to me:
Single table, with three fields: QUESTION, ANSWER, CATEGORY.
Unless you are talking about writing a system that acts as an automated quiz system that people interact with, in which case its a lot more complex.
Jun 03, 2021 10:49 AM
I dont find it that simple, as i see it i need 6 different tabels: QUIZS, QUESTIONS, ANSWERS, HINTS, CATEGORY and TYPES.
The only purpose it to allow the user to create a new quiz within any given type and category, and then Zapier should send the data to Webflow CMS.