Changes between Initial Version and Version 1 of TakingQuiz

Timestamp:

01/22/26 03:47:24 (17 hours ago)

Author:

221296

Comment:

--

TakingQuiz

@@ +1 @@
+== Taking a Quiz
+
+==== Actors: **Registered User (USER)**
+
+**1.** Load Quiz for a Lesson.
+
+{{{#!sql
+SELECT quiz_id, total_points, passing_score
+FROM quiz
+WHERE lesson_id = :lessonId;
+
+
+}}}
+
+
+**2.** Store Quiz Attempt.
+
+
+{{{#!sql
+INSERT INTO quiz_attempt (score, attempt_date, user_id, quiz_id)
+VALUES (:score, CURRENT_DATE, :userId, :quizId);
+
+}}}
+
+**3.** Check Quiz Result.
+
+
+{{{#!sql
+SELECT CASE
+     WHEN :score >= passing_score THEN 'PASSED'
+     ELSE 'FAILED'
+     END AS result
+FROM quiz
+WHERE quiz_id = :quizId;
+
+}}}