UC0005 - Create Event Edition and Programme

Initiating actor: Board Member

A Board Member creates an event edition and defines its main data. The scenario creates Job Fair 2027 with locations, function slots, and programme sessions.

Scenario

1. The Board Member opens the event administration page.

2. The application lists event types.

SELECT
    et_name,
    et_description
FROM event_types
ORDER BY et_name;

3. The Board Member enters the event edition data.

4. The application stores the event edition.

INSERT INTO event_editions (
    et_name,
    event_title,
    event_start_time,
    event_end_time
)
VALUES (
    'Job Fair',
    'Job Fair 2027',
    TIMESTAMP '2027-03-22 09:00:00',
    TIMESTAMP '2027-03-26 18:00:00'
);

5. The Board Member enters the event locations.

6. The application stores the event locations.

INSERT INTO event_edition_locations (
    et_name,
    event_title,
    event_start_time,
    location
)
VALUES
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'INNOFEIT'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'FEEIT'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'MFS');

7. The Board Member enters the planned event function slots.

8. The application stores the event function slots.

INSERT INTO core_team_functions (
    et_name,
    event_title,
    event_start_time,
    function_name
)
VALUES
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Main Organiser 1'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Main Organiser 2'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Corporate Relations Responsible 1'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Corporate Relations Responsible 2'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Logistics Responsible'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'PR Responsible'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'FR Responsible'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'IT Responsible'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Design Responsible');

9. The Board Member enters programme sessions.

10. The application stores the programme sessions.

INSERT INTO event_sessions (
    et_name,
    event_title,
    event_start_time,
    est_name,
    es_start_time,
    location,
    es_title
)
VALUES
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00',
     'Official Opening', TIMESTAMP '2027-03-22 10:00:00', 'INNOFEIT', 'Job Fair Opening Ceremony'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00',
     'Company Stands', TIMESTAMP '2027-03-23 10:00:00', 'FEEIT', 'Technical Companies Stands'),
    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00',
     'Company Stands', TIMESTAMP '2027-03-23 10:00:00', 'MFS', 'Engineering Companies Stands');

11. The application shows the programme for Job Fair 2027.

SELECT
    es.est_name,
    es.es_start_time,
    es.location,
    es.es_title
FROM event_sessions es
WHERE es.et_name = 'Job Fair'
  AND es.event_title = 'Job Fair 2027'
  AND es.event_start_time = TIMESTAMP '2027-03-22 09:00:00'
ORDER BY es.es_start_time, es.location, es.est_name;

12. The application shows the function slots for Job Fair 2027.

SELECT
    ctf.function_name
FROM core_team_functions ctf
WHERE ctf.et_name = 'Job Fair'
  AND ctf.event_title = 'Job Fair 2027'
  AND ctf.event_start_time = TIMESTAMP '2027-03-22 09:00:00'
ORDER BY ctf.function_name;