Changes between Initial Version and Version 1 of UseCase0002

Timestamp:

08/29/26 18:50:16 (8 days ago)

Author:

236024

Comment:

--

UseCase0002

@@ +1 @@
+= UC0002 - Create Activity Session =
+
+'''Initiating actor:''' Board Member
+
+A Board Member creates an activity session and records who is responsible for it. The scenario creates a PR workshop connected to BEST Course in Summer 2026.
+
+== Scenario ==
+
+1. The Board Member opens the activity session creation form.
+
+2. The application lists available activity types.
+
+{{{#!sql
+SELECT
+    at_name,
+    at_description
+FROM activity_types
+ORDER BY at_name;
+}}}
+
+3. The Board Member enters the activity session data.
+
+4. The application stores the activity session.
+
+{{{#!sql
+INSERT INTO activity_sessions (
+    at_name,
+    as_start_time,
+    as_location
+)
+VALUES (
+    'PR Workshop',
+    TIMESTAMP '2026-06-22 17:00:00',
+    'Baraka 2.1'
+);
+}}}
+
+5. The application records the responsible member.
+
+{{{#!sql
+INSERT INTO responsible_for (
+    student_index,
+    at_name,
+    as_start_time,
+    as_location
+)
+VALUES (
+    230006,
+    'PR Workshop',
+    TIMESTAMP '2026-06-22 17:00:00',
+    'Baraka 2.1'
+);
+}}}
+
+6. The application links the activity session to BEST Course in Summer 2026.
+
+{{{#!sql
+INSERT INTO related_to (
+    at_name,
+    as_start_time,
+    as_location,
+    et_name,
+    event_title,
+    event_start_time
+)
+VALUES (
+    'PR Workshop',
+    TIMESTAMP '2026-06-22 17:00:00',
+    'Baraka 2.1',
+    'BEST Course in Summer',
+    'BEST Course in Summer 2026',
+    TIMESTAMP '2026-07-05 12:00:00'
+);
+}}}
+
+7. The application shows the created activity session.
+
+{{{#!sql
+SELECT
+    a.at_name,
+    a.as_start_time,
+    a.as_location,
+    s.first_name || ' ' || s.last_name AS responsible_member,
+    rt.et_name,
+    rt.event_title
+FROM activity_sessions a
+JOIN responsible_for rf
+    ON rf.at_name = a.at_name
+   AND rf.as_start_time = a.as_start_time
+   AND rf.as_location = a.as_location
+JOIN students s
+    ON s.student_index = rf.student_index
+LEFT JOIN related_to rt
+    ON rt.at_name = a.at_name
+   AND rt.as_start_time = a.as_start_time
+   AND rt.as_location = a.as_location
+WHERE a.at_name = 'PR Workshop'
+  AND a.as_start_time = TIMESTAMP '2026-06-22 17:00:00'
+  AND a.as_location = 'Baraka 2.1';
+}}}