James01010101 / YouTube_Shorts_Video_Editing

Youtube shorts quizzes video editing using Web and Java backend
1 stars 0 forks source link

Draw up a Database schema of how the database will look #2

Open James01010101 opened 5 months ago

James01010101 commented 5 months ago

Organise what data needs to be stored for each topic and each quiz and how will I connect those tables

Topic Table with a list of all topics each will connect to a quizzes table which stores the quizzes for that topic

Might want to just have the first table have the heading of topics and the list of quizzes. need to remember how this works first

each quizzes table will store a list of the different quizzes these will point to a quiz table

then the quiz table stores the settings file, and all of the audio files, I could store them by section in their own table too.