UC0006 - Submit Application

Initiating actor: Student

A Student submits an application for an event participation process. The scenario stores a new student and their Hackathon participation application.

Scenario

1. The Student opens the Hackathon participation application form.

2. The application lists event editions that accept participation applications.

SELECT
    ee.et_name,
    ee.event_title,
    ee.event_start_time,
    ee.event_end_time
FROM event_editions ee
WHERE ee.et_name IN ('Hackathon', 'BEST Course in Summer')
ORDER BY ee.event_start_time;

3. The Student enters personal data and chooses Impact Hackathon 2026.

4. The application stores the student data.

INSERT INTO students (
    student_index,
    first_name,
    last_name,
    faculty,
    field_of_studies,
    year_of_studies,
    birthday,
    email,
    phone_number
)
VALUES (
    230033,
    'Martina',
    'Ilievska',
    'FINKI',
    'Software Engineering and Information Systems',
    2,
    DATE '2004-10-12',
    'martina.ilievska@student.ukim.mk',
    '+38970111033'
);

5. The Student enters a motivational letter.

6. The application stores the submitted application.

INSERT INTO applications (
    student_index,
    et_name,
    event_title,
    event_start_time,
    function_name,
    motivational_letter,
    application_type,
    application_status
)
VALUES (
    230033,
    'Hackathon',
    'Impact Hackathon 2026',
    TIMESTAMP '2026-12-12 09:00:00',
    NULL,
    'I want to participate in the hackathon because I want to solve a real challenge with a team and improve my practical skills.',
    'event_participation',
    'submitted'
);

7. The application shows the submitted application.

SELECT
    a.application_id,
    s.first_name,
    s.last_name,
    a.et_name,
    a.event_title,
    a.function_name,
    a.application_type,
    a.application_status
FROM applications a
JOIN students s
    ON s.student_index = a.student_index
WHERE s.email = 'martina.ilievska@student.ukim.mk'
  AND a.et_name = 'Hackathon'
  AND a.event_title = 'Impact Hackathon 2026'
  AND a.event_start_time = TIMESTAMP '2026-12-12 09:00:00';