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.