UC0005 - Create Event Edition and Event Functions

Initiating actor: Board Member

A Board Member creates an event edition, adds its locations, and defines event functions. In this scenario, the Board Member is acting as the President.

Scenario

1. The Board Member opens the create event edition page.

2. The application lists event types and locations.

SELECT et_id, et_name
FROM event_types
ORDER BY et_name;

SELECT l_id, l_name
FROM locations
ORDER BY l_name;

3. The Board Member enters Job Fair 2027 with the selected event type and dates.

4. The application stores the event edition.

INSERT INTO event_editions (
    ee_id,
    et_id,
    ee_title,
    ee_start_time,
    ee_end_time
) VALUES (
    1001,
    2,
    'Job Fair 2027',
    TIMESTAMP '2027-03-22 09:00:00',
    TIMESTAMP '2027-03-26 18:00:00'
);

5. The application stores the event edition locations.

INSERT INTO event_edition_locations (ee_id, l_id) VALUES
    (1001, 12),
    (1001, 13),
    (1001, 14);

6. The application stores the event function slots.

INSERT INTO event_functions (ee_id, ef_no, ef_name) VALUES
    (1001, 1, 'Main Organiser 1'),
    (1001, 2, 'Main Organiser 2'),
    (1001, 3, 'Corporate Relations Responsible 1'),
    (1001, 4, 'Corporate Relations Responsible 2'),
    (1001, 5, 'Logistics Responsible'),
    (1001, 6, 'PR Responsible'),
    (1001, 7, 'FR Responsible'),
    (1001, 8, 'IT Responsible'),
    (1001, 9, 'Design Responsible');

7. The application shows the created event edition, locations, and event functions.

SELECT
    ee.ee_id,
    et.et_name,
    ee.ee_title,
    ee.ee_start_time,
    ee.ee_end_time
FROM event_editions ee
JOIN event_types et
    ON et.et_id = ee.et_id
WHERE ee.ee_id = 1001;

SELECT
    l.l_id,
    l.l_name
FROM event_edition_locations eel
JOIN locations l
    ON l.l_id = eel.l_id
WHERE eel.ee_id = 1001
ORDER BY l.l_name;

SELECT ef_no, ef_name
FROM event_functions
WHERE ee_id = 1001
ORDER BY ef_no;