= 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.