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 application page.

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

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 et.et_name IN ('Hackathon', 'BEST Course in Summer')
  AND ee.ee_start_time >= CURRENT_TIMESTAMP
ORDER BY ee.ee_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 application stores the submitted application.

INSERT INTO applications (
    student_index,
    ee_id,
    ef_no,
    motivational_letter,
    application_type,
    application_status
) VALUES (
    230033,
    8,
    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'
);

6. The application shows the submitted application.

SELECT
    a.application_id,
    s.first_name,
    s.last_name,
    et.et_name,
    ee.ee_title,
    a.application_type,
    a.application_status
FROM applications a
JOIN students s
    ON s.student_index = a.student_index
JOIN event_editions ee
    ON ee.ee_id = a.ee_id
JOIN event_types et
    ON et.et_id = ee.et_id
WHERE a.student_index = 230033
  AND a.ee_id = 8;