Changes between Version 1 and Version 2 of UC2001

Timestamp:

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

Author:

216009

Comment:

--

UC2001

@@ -3 +3 @@
 **Initiating actor:** Professor
 
-**Other actors:** Student
+**Other actors:** None
 
 **Description:**
-A professor records the final grade for a student enrolled in a subject.
+A professor records the final grade for a student enrolled in a subject under their supervision.
 
 **Scenario:**
@@ -12 +12 @@
 1. Professor logs in and selects “Enter Grades.”
 
-2. System shows subjects the professor teaches:
+2. System shows students and subjects that this specific professor teaches:
 {{{
-SELECT sub.Id, sub.Name, st.Id AS Student_Id, st.Name, st.Surname
-FROM Subject sub
-JOIN Subject_Professor sp ON sp.Subject_Id = sub.Id
-JOIN Student_Subject ss ON ss.Subject_Id = sub.Id
-JOIN Student st ON st.Id = ss.Student_Id
-WHERE sp.Professor_Id = :professor_id;
+SELECT 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
+JOIN Student st ON ss.Student_Id = st.Id
+WHERE ss.Professor_Id = :professor_id;
 }}}
 
-3. Professor selects a student and enters the final grade.
+3. Professor selects a student/subject entry and enters the final grade.
 
-4. System updates the database:
+4. System updates the database with the grade and changes status to 'PASSED' (or 'FAILED' depending on the grade):
 {{{
 UPDATE Student_Subject
-SET Final_Grade = :grade, Status = 'COMPLETED'
-WHERE Student_Id = :student_id AND Subject_Id = :subject_id;
+SET Final_Grade = :grade, Status = 'PASSED'
+WHERE Student_Id = :student_id AND Subject_Id = :subject_id AND Professor_Id = :professor_id;
 }}}
 
-5. System confirms the update and allows professor to continue for other students.
+5. System confirms the update and allows the professor to continue grading other students.