Database

Course is a standard moodle table

Contains (course-livequiz) is the relationship table between Course and Livequiz The relationship is many-to-one, with 'one' being the course. Since a course can have all livequiz', but a livequiz can only be associated with one course

Livequiz has the following parameters: id, name, course, intro, introformat, timecreated, timemodified

Created by (livequiz-lecturer) is the relationship between lecturer and livequiz, and is many-to-one, as a lecturer can create all livequiz', but a livequiz can only be created by a lecturer

Lecturer refers to the user who creates a quiz/question. In practice, a standard moodle table named “mdl_user” is used.

Question are the questions that belong to a quiz. They have the parameters: id, title, description, timelimit and explanation. Explanation allows you to provide an explanation for the entire question, if you prefer, rather than providing explanations for each answer option.

Consists of (livequiz-question) relationship between question and livequiz, and is many to one, as a live quiz can have many questions, but a question can only be associated with one live quiz. In case of 'reused' questions, only duplicates will be used

Created by (question-lecturer) relationship between question and lecturer. This is many-to-one, as a lecturer can create all questions, but a question can only be created by one lecturer

Participates (livequiz-students) relationship between live quizzes and students. This is many-to-many, as students can participate in all live quizzes, and live quizzes can have many students

Students are students from the default moodle table “mdl_user”.

Chooses is a relationship between: students, answers or participates Here each answer a student makes will be stored, with the corresponding participationid, to distinguish between students' answers and their participation (to recognize one quiz run from another)

Answer is the answer options for a question. It has the parameters: id, correct, explanation and description. Explanation can be used to provide explanations for each option.

Contains (question-answer) relationship between answer and question. This relationship is many to one, as a question can have all answers, but an answer can only be associated with one question