Changes between Version 1 and Version 2 of UseCase0004

Timestamp:

09/02/26 18:04:03 (4 days ago)

Author:

236024

Comment:

--

UseCase0004

@@ -3 +3 @@
 '''Initiating actor:''' Board Member
 
-A Board Member records attendance for a Full Member Meeting. The scenario checks attendance for the Full Member Meeting held on 12 March 2026.
+A Board Member opens a Full Member Meeting attendance list and records attendance statuses for full members. In this scenario, the Board Member is acting as the Secretary.
 
 == Scenario ==
 
-1. The Board Member opens the attendance screen for the Full Member Meeting.
+1. The Board Member opens the attendance page for the Full Member Meeting on 12 March 2026.
 
-2. The application lists full members with their RSVP, attendance status, and absence reason if one exists.
+2. The application lists full members with their RSVP, attendance status, and announced absence if one exists.
 
 {{{#!sql
@@ -16 +16 @@
     s.first_name,
     s.last_name,
-    COALESCE(p.rsvp_status, 'no_response') AS rsvp_status,
-    COALESCE(p.attendance_status, 'not_checked') AS attendance_status,
+    p.rsvp_status,
+    p.attendance_status,
     aa.reason
 FROM full_members fm
@@ -24 +24 @@
 LEFT JOIN participation p
     ON p.student_index = fm.student_index
-   AND p.at_name = 'Full Member Meeting'
-   AND p.as_start_time = TIMESTAMP '2026-03-12 18:00:00'
-   AND p.as_location = 'BEST Office'
+   AND p.as_id = 8
 LEFT JOIN announces_absence aa
     ON aa.student_index = fm.student_index
-   AND aa.at_name = 'Full Member Meeting'
-   AND aa.as_start_time = TIMESTAMP '2026-03-12 18:00:00'
-   AND aa.as_location = 'BEST Office'
+   AND aa.as_id = 8
 ORDER BY s.last_name, s.first_name;
 }}}
 
-3. The Board Member marks Mila Jovanovska as excused.
+3. The Board Member marks member 230005 as excused.
 
 4. The application updates the attendance status.
@@ -43 +39 @@
 SET attendance_status = 'excused'
 WHERE student_index = 230005
-  AND at_name = 'Full Member Meeting'
-  AND as_start_time = TIMESTAMP '2026-03-12 18:00:00'
-  AND as_location = 'BEST Office';
+  AND as_id = 8;
 }}}
 
-5. The application refreshes the attendance list.
+5. The application shows the updated attendance row.
 
 {{{#!sql
@@ -56 +50 @@
     s.last_name,
     p.rsvp_status,
-    p.rsvp_at,
-    p.attendance_status
+    p.attendance_status,
+    aa.reason
 FROM participation p
 JOIN students s
     ON s.student_index = p.student_index
-WHERE p.at_name = 'Full Member Meeting'
-  AND p.as_start_time = TIMESTAMP '2026-03-12 18:00:00'
-  AND p.as_location = 'BEST Office'
-ORDER BY s.last_name, s.first_name;
+LEFT JOIN announces_absence aa
+    ON aa.student_index = p.student_index
+   AND aa.as_id = p.as_id
+WHERE p.student_index = 230005
+  AND p.as_id = 8;
 }}}