Changes between Version 1 and Version 2 of UC3003

Timestamp:

06/15/26 14:17:31 (2 days ago)

Author:

216009

Comment:

--

UC3003

@@ -3 +3 @@
 **Initiating actor:** Student
 
-**Other actors:** Professor
+**Other actors:** None
 
 **Description:**
-Student requests academic advising from a professor.
+Student requests academic advising from a professor within their faculty.
 
 **Scenario:**
 
-1. Student selects “Request Advisor”
+1. Student selects “Request Advisor”.
 
 2. System lists professors available in the student’s faculty:
@@ -16 +16 @@
 SELECT p.Id, p.Name, p.Surname
 FROM Professor p
-JOIN Faculty f ON p.Faculty_Id = f.Id
-JOIN Student st ON st.Faculty_Id = f.Id
+JOIN Student st ON st.Faculty_Id = p.Faculty_Id
 WHERE st.Id = :student_id;
 }}}
 
-3. Student selects professor and sends request.
+3. Student selects a professor and submits the request.
 
-4. System creates advising relationship (pending or immediate):
+4. System creates the advising relationship in the database:
 {{{
 INSERT INTO Advice(Student_Id, Professor_Id, Start_Date, End_Date)
-VALUES (:student_id, :professor_id, CURRENT_DATE, NULL);
+VALUES (:student_id, :professor_id, :start_date, :end_date);
 }}}