Changes between Version 4 and Version 5 of UseCase2001Implementation

Timestamp:

06/15/26 14:28:39 (38 hours ago)

Author:

216009

Comment:

--

UseCase2001Implementation

@@ -3 +3 @@
 **Initiating actor:** Professor
 
-**Other actors:** Student
+**Other actors:** None
 
-**Description:** Professor assigns grades to enrolled students.
+**Description:** Professor assigns final grades to students enrolled in their course instances.
 
 **Scenario:**
@@ -13 +13 @@
 2. Professor selects Assign Grade.
 
-3. System lists professors → Professor selects ID.
+3. System prompts the professor to enter their Professor ID.
 
-4. System lists subjects taught by that professor → selects subject.
+4. System lists all unique subjects where this professor is assigned to students:
+{{{
+SELECT DISTINCT s.Id, s.Name 
+FROM Subject s 
+JOIN Student_Subject ss ON s.Id = ss.Subject_Id 
+WHERE ss.Professor_Id = ?;
+}}}
+Professor selects a Subject ID.
 
-5. System lists enrolled students → selects student.
+5. System lists students enrolled in that specific subject under this professor:
+{{{
+SELECT st.Id, st.Name, st.Surname 
+FROM Student st 
+JOIN Student_Subject ss ON st.Id = ss.Student_Id 
+WHERE ss.Subject_Id = ? AND ss.Professor_Id = ?;
+}}}
+Professor selects a Student ID.
 
-6. System prompts for grade (6–10).
+6. System prompts for the final grade (6–10).
 
-7. System executes SQL:
+7. System executes SQL to update the student's grade and status:
 {{{
 UPDATE Student_Subject
 SET Final_Grade = ?, Status = 'PASSED'
-WHERE Student_Id = ? AND Subject_Id = ?;
+WHERE Student_Id = ? AND Subject_Id = ? AND Professor_Id = ?;
 }}}
 
-8. System confirms grade assignment.
-[[Image(assignGrade1.jpg, 800px)]]
+8. System confirms grade assignment successfully.
+
+[[Image(assignGrade1.png, 800px)]]
 [[Image(assignGrade2.jpg, 800px)]]
 [[Image(assignGrade3.jpg, 800px)]]