Hello,

I am developing a database for a school, and l have got all the tables designed, but l have a few questions about the table that will be used to store data for an exam.

The teacher will write the exam and could have 20 questions 25, or 30 questions. This depends on the teacher writing the exam, they could have as many as they want. So how could l develop the database inconsist number of questions? Should l have the maximum number of questions a teacher could have.

The teacher will write the questions and these would be stored in the table. The exam could contain multiple choice or written exams questions. The relationship is a 1 teacher writes many exams. So it is a 1 to many relationship.

How would l design a table with this data. The individual questions could be text datatype, and the multiple choice could be boolean.

Many thanks in advance

Steve