UseCase3003 – Request Advice

Initiating actor: Student

Other actors: None

Description: Student requests academic advising from a professor within their faculty.

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 Student st ON st.Faculty_Id = p.Faculty_Id
   WHERE st.Id = :student_id;
   

3. Student selects a professor and submits the request.

4. System creates the advising relationship in the database:

   INSERT INTO Advice(Student_Id, Professor_Id, Start_Date, End_Date)
   VALUES (:student_id, :professor_id, :start_date, :end_date);
   

5. System confirms request submission.