UC0002 - Create Activity Session

Initiating actor: Board Member

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

1. The Board Member opens the activity session creation form.

2. The application lists available activity types and locations.

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;

3. The Board Member enters the activity session data.

4. The application stores the activity session.

INSERT INTO activity_sessions (
    as_id,
    at_id,
    l_id,
    as_start_time
)
VALUES (
    1001,
    5,
    2,
    TIMESTAMP '2026-06-22 17:00:00'
);

5. The application records the responsible member.

INSERT INTO responsible_for (
    student_index,
    as_id
)
VALUES (
    230006,
    1001
);

6. The application links the activity session to BEST Course in Summer 2026.

INSERT INTO related_to (
    as_id,
    ee_id
)
VALUES (
    1001,
    6
);

7. The application shows the created activity session.

SELECT
    a.as_id,
    at.at_name,
    a.as_start_time,
    l.l_name,
    s.first_name || ' ' || s.last_name AS responsible_member,
    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.as_id = a.as_id
JOIN students s
    ON s.student_index = rf.student_index
LEFT JOIN related_to rt
    ON rt.as_id = a.as_id
LEFT JOIN event_editions ee
    ON ee.ee_id = rt.ee_id
WHERE a.as_id = 1001;