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