Which question?
We offered three different designs to do your survey:
1. Each courses has a well defined specific group of questions.
Advantage: Easy to analize
Disadvantage: A huge amount of groups. You may run into trouble because of the length limitation of MySQL
2. Master-Slave
Advantage; A more or less relational database to analyze
Disadvantage: Some brains needed to understand the logic
3. Micro-Tayloring of course-groups
Advantage: Short and easy to unterstand survey
Disadvantage: Some work to restructure the courses before analyzing them.
Now it's up to you.
The semester is checked from participant table
eah I need to make it open survey where student can select their department and his courses will shown to evaluate.
So, what???
Is it an open survey or a closed survey?
What's the difference.
If it's closed you may have the semester and department in the participants table and the subquestion relevance equation of courses is taken from the TOKEN:ATTRIBUTEs in the participants tsble.
If it is an open survey you have no participants table and have to ask for these details.
And the subquestion relevance equation is taken from the choice of department.