Changes between Initial Version and Version 1 of UseCase0006

Timestamp:

08/29/26 19:11:44 (8 days ago)

Author:

236024

Comment:

--

UseCase0006

@@ +1 @@
+= 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.
+
+{{{#!sql
+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.
+
+{{{#!sql
+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.
+
+{{{#!sql
+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.
+
+{{{#!sql
+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';
+}}}