Changes between Initial Version and Version 1 of UC3003

Timestamp:

02/04/26 12:56:34 (3 weeks ago)

Author:

216009

Comment:

--

UC3003

@@ +1 @@
+= UseCase3003 – Request Advice
+
+**Initiating actor:** Student
+
+**Other actors:** Professor
+
+**Description:**
+Student requests academic advising from a professor.
+
+**Scenario:**
+
+1. Student selects “Request Advisor”
+
+2. System lists professors available in the student’s faculty:
+{{{
+SELECT p.Id, p.Name, p.Surname
+FROM Professor p
+JOIN Faculty f ON p.Faculty_Id = f.Id
+JOIN Student st ON st.Faculty_Id = f.Id
+WHERE st.Id = :student_id;
+}}}
+
+3. Student selects professor and sends request.
+
+4. System creates advising relationship (pending or immediate):
+{{{
+INSERT INTO Advice(Student_Id, Professor_Id, Start_Date, End_Date)
+VALUES (:student_id, :professor_id, CURRENT_DATE, NULL);
+}}}
+
+5. System confirms request submission.