Changes between Initial Version and Version 1 of UC2002


Ignore:
Timestamp:
02/04/26 12:47:13 (3 weeks ago)
Author:
216009
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UC2002

    v1 v1  
     1= UseCase2002 – Advise Student
     2
     3**Initiating actor:** Professor
     4**Other actors:** Student
     5
     6**Description:**
     7A professor becomes an academic advisor to a student for a specific period.
     8
     9**Scenario:**
     10
     111. Professor selects “Start Advising Student”
     12
     132. System shows list of students in professor’s faculty:
     14{{{
     15SELECT st.Id, st.Name, st.Surname
     16FROM Student st
     17JOIN Faculty f ON st.Faculty_Id = f.Id
     18JOIN Professor p ON p.Faculty_Id = f.Id
     19WHERE p.Id = :professor_id;
     20}}}
     21
     223. Professor selects student and enters advising dates.
     23
     244. System inserts advising relationship:
     25{{{
     26INSERT INTO Advice(Student_Id, Professor_Id, Start_Date, End_Date)
     27VALUES (:student_id, :professor_id, CURRENT_DATE, :end_date);
     28}}}
     29
     305. System confirms advisor assignment.