Changes between Version 2 and Version 3 of UC2001

Timestamp:

06/25/26 15:29:21 (13 hours ago)

Author:

216009

Comment:

--

UC2001

@@ -1 @@
-= UseCase2001 – Assign Grade to Student
+== UC2001 – Assign Grade to Student ==
 
-**Initiating actor:** Professor
+'''Initiating actor:''' Professor
+'''Other actors:''' None
 
-**Other actors:** None
-
-**Description:**
+'''Description:'''
 A professor records the final grade for a student enrolled in a subject under their supervision.
 
-**Scenario:**
-
+'''Scenario:'''
 1. Professor logs in and selects “Enter Grades.”
-
-2. System shows students and subjects that this specific professor teaches:
+2. System shows students and subjects that this specific professor teaches (вклучувајќи го и Ss_Id):
 {{{
-SELECT sub.Id AS Subject_Id, sub.Name AS Subject_Name, st.Id AS Student_Id, st.Name, st.Surname
+SELECT ss.Ss_Id, sub.Id AS Subject_Id, sub.Name AS Subject_Name, st.Id AS Student_Id, st.Name, st.Surname
 FROM Student_Subject ss
 JOIN Subject sub ON ss.Subject_Id = sub.Id
@@ -20 +17 @@
 WHERE ss.Professor_Id = :professor_id;
 }}}
-
 3. Professor selects a student/subject entry and enters the final grade.
-
-4. System updates the database with the grade and changes status to 'PASSED' (or 'FAILED' depending on the grade):
+4. System updates the database with the grade and changes status to 'Passed' (усогласено со композитниот клуч и ENUM):
 {{{
 UPDATE Student_Subject
-SET Final_Grade = :grade, Status = 'PASSED'
-WHERE Student_Id = :student_id AND Subject_Id = :subject_id AND Professor_Id = :professor_id;
+SET Final_Grade = :grade, Status = 'Passed'
+WHERE Student_Id = :student_id AND Subject_Id = :subject_id AND Ss_Id = :ss_id;
 }}}
+5. System confirms the update and allows the professor to continue grading other students.
 
-5. System confirms the update and allows the professor to continue grading other students.
+
+== UC2002 – 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.