Changes between Version 1 and Version 2 of UseCase0002

Timestamp:

09/02/26 20:29:29 (4 days ago)

Author:

236024

Comment:

--

UseCase0002

@@ -3 +3 @@
 '''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.
+A Board Member creates an activity session and records who is responsible for it. In this scenario, the Board Member is acting as the PR Coordinator and creates a PR workshop connected to BEST Course in Summer 2026.
 
 == Scenario ==
@@ -9 +9 @@
 1. The Board Member opens the activity session creation form.
 
-2. The application lists available activity types.
+2. The application lists available activity types and locations.
 
 {{{#!sql
 SELECT
+    at_id,
     at_name,
     at_description
 FROM activity_types
 ORDER BY at_name;
+
+SELECT
+    l_id,
+    l_name
+FROM locations
+ORDER BY l_name;
 }}}
 
@@ -25 +32 @@
 {{{#!sql
 INSERT INTO activity_sessions (
-    at_name,
-    as_start_time,
-    as_location
+    as_id,
+    at_id,
+    l_id,
+    as_start_time
 )
 VALUES (
-    'PR Workshop',
-    TIMESTAMP '2026-06-22 17:00:00',
-    'Baraka 2.1'
+    1001,
+    5,
+    2,
+    TIMESTAMP '2026-06-22 17:00:00'
 );
 }}}
@@ -41 +50 @@
 INSERT INTO responsible_for (
     student_index,
-    at_name,
-    as_start_time,
-    as_location
+    as_id
 )
 VALUES (
     230006,
-    'PR Workshop',
-    TIMESTAMP '2026-06-22 17:00:00',
-    'Baraka 2.1'
+    1001
 );
 }}}
@@ -57 +62 @@
 {{{#!sql
 INSERT INTO related_to (
-    at_name,
-    as_start_time,
-    as_location,
-    et_name,
-    event_title,
-    event_start_time
+    as_id,
+    ee_id
 )
 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'
+    1001,
+    6
 );
 }}}
@@ -78 +75 @@
 {{{#!sql
 SELECT
-    a.at_name,
+    a.as_id,
+    at.at_name,
     a.as_start_time,
-    a.as_location,
+    l.l_name,
     s.first_name || ' ' || s.last_name AS responsible_member,
-    rt.et_name,
-    rt.event_title
+    ee.ee_title
 FROM activity_sessions a
+JOIN activity_types at
+    ON at.at_id = a.at_id
+JOIN locations l
+    ON l.l_id = a.l_id
 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
+    ON rf.as_id = a.as_id
 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';
+    ON rt.as_id = a.as_id
+LEFT JOIN event_editions ee
+    ON ee.ee_id = rt.ee_id
+WHERE a.as_id = 1001;
 }}}