= UseCase2002 – Advise Student

**Initiating actor:** Professor

**Other actors:** Student

**Description:**
A professor becomes an academic advisor to a student for a specific period.

**Scenario:**

1. Professor selects “Start Advising Student”

2. System shows list of students in professor’s faculty:
{{{
SELECT st.Id, st.Name, st.Surname
FROM Student st
JOIN Faculty f ON st.Faculty_Id = f.Id
JOIN Professor p ON p.Faculty_Id = f.Id
WHERE p.Id = :professor_id;
}}}

3. Professor selects student and enters advising dates.

4. System inserts advising relationship:
{{{
INSERT INTO Advice(Student_Id, Professor_Id, Start_Date, End_Date)
VALUES (:student_id, :professor_id, CURRENT_DATE, :end_date);
}}}

5. System confirms advisor assignment.