Changes between Version 2 and Version 3 of UC2002

Timestamp:

06/15/26 14:15:38 (2 days ago)

Author:

216009

Comment:

--

UC2002

@@ -3 +3 @@
 **Initiating actor:** Professor
 
-**Other actors:** Student
+**Other actors:** None
 
 **Description:**
-A professor becomes an academic advisor to a student for a specific period.
+A professor records an academic advising relationship with a student for a specific time period.
 
 **Scenario:**
 
-1. Professor selects “Start Advising Student”
+1. Professor selects “Start Advising Student”.
 
-2. System shows list of students in professor’s faculty:
+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 Faculty f ON st.Faculty_Id = f.Id
-JOIN Professor p ON p.Faculty_Id = f.Id
+JOIN Professor p ON p.Faculty_Id = st.Faculty_Id
 WHERE p.Id = :professor_id;
 }}}
 
-3. Professor selects student and enters advising dates.
+3. Professor selects a student and enters the advising start and end dates.
 
-4. System inserts advising relationship:
+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, CURRENT_DATE, :end_date);
+VALUES (:student_id, :professor_id, :start_date, :end_date);
 }}}
 
-5. System confirms advisor assignment.
+5. System confirms the advisor assignment.