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.