= UseCase2002 – Advise Student

**Initiating actor:** Professor

**Other actors:** None

**Description:**
A professor records an academic advising relationship with a student for a specific time period.

**Scenario:**

1. Professor selects “Start Advising Student”.

2. System shows a list of students belonging to the same faculty as the professor:
{{{
SELECT st.Id, st.Name, st.Surname
FROM Student st
JOIN Professor p ON p.Faculty_Id = st.Faculty_Id
WHERE p.Id = :professor_id;
}}}

3. Professor selects a student and enters the advising start and end dates.

4. System inserts the advising record into 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 the advisor assignment.