I'm not sure if topic can get you understand what I want to explain. Follow guide in my old question, now I have these tables and its columns:
name, description, semester, number_question (total number of questions of general exam), duration, used (boolean), user_id, course_id
To sum up association:
- Course - Topic: one-to-many
- Topic - Question: one-to-many
- Course - GeneralExam: one-to-many
- Question - GeneralExam: many-to-many, join table: GeneralQuestion
Now, When creating new General Exam (GE) for a course, I want to specific a number of questions for each topic of that course, so that I can get questions for that GE ( I want to do(specific) it on form, I had a form for create new GE now). So, should I create new table to store a number of questions of each topic of course when creating new GE? If I should, how table I should design?
I image table I should design will like this (I can't get name of table now):
NameOfTable: general_exam_id, course_id, topic_id, number_question
Is this table good?