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.