Changes between Version 7 and Version 8 of UseCase2001Implementation

Timestamp:

09/09/26 13:14:49 (31 hours ago)

Author:

216009

Comment:

--

UseCase2001Implementation

@@ -20 +20 @@
 Professor inputs a target Subject ID from the displayed list.
 
-5. System lists all students currently enrolled in that chosen subject under this professor's instruction:
+5. System lists all students currently enrolled in that chosen subject under this professor's instruction (including the Ss_Id discriminator):
 {{{
-SELECT st.Id, st.Name, st.Surname 
+SELECT ss.Ss_Id, st.Id AS Student_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 inputs the target Student ID.
+Professor inputs the target Student ID and Ss_Id.
 
 6. System prompts the professor to provide a valid final grade value (constrained between 6 and 10).
-7. System executes the parameterized SQL statement to persist the final grade and modify the completion status:
+7. System executes the parameterized SQL statement to persist the final grade using the full composite primary key and correct ENUM value:
 {{{
 UPDATE Student_Subject
-SET Final_Grade = ?, Status = 'PASSED'
-WHERE Student_Id = ? AND Subject_Id = ? AND Professor_Id = ?;
+SET Final_Grade = ?, Status = 'Passed'
+WHERE Student_Id = ? AND Subject_Id = ? AND Ss_Id = ?;
 }}}
 8. System displays a confirmation text message indicating that the grade was successfully assigned.