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