Changes between Version 8 and Version 9 of UseCase2001Implementation

Timestamp:

09/10/26 12:18:36 (8 hours ago)

Author:

216009

Comment:

--

UseCase2001Implementation

@@ -1 +1 @@
 == UC2001 – Assign Grade to Student Implementation ==
 
-'''Initiating actor:''' Professor
-'''Other actors:''' None
+'''Initiating actor:''' Administrator
+'''Other actors:''' Professor
 
 '''Description:''' 
-Professor inputs and records final grades for students enrolled in specific subject course instances using the console interface.
+Administrator updates an existing student subject enrollment record via the Web UI dashboard to record and persist the final grade assigned by the professor.
 
 '''Scenario:'''
-1. System displays the Professor Menu interface.
-2. Professor selects the option to "Assign Grade to Student".
-3. System prompts the professor to input their unique Professor ID.
-4. System retrieves and lists all unique subjects where this professor has active student enrollments:
+1. Administrator navigates to the "Student Subject Enrollments" overview page from the Admin dashboard.
+2. System queries the database and displays the list of active student enrollments:
 {{{
-SELECT DISTINCT s.Id, s.Name 
-FROM Subject s 
-JOIN Student_Subject ss ON s.Id = ss.Subject_Id 
-WHERE ss.Professor_Id = ?;
+SELECT Ss_Id AS ID, Student_Id, Subject_Id, Enrollment_Date, Status, Final_Grade AS Grade, Absences_Count AS Absences
+FROM Student_Subject;
 }}}
-Professor inputs a target Subject ID from the displayed list.
+[[Image(enrollment_table.png, 800px)]]
 
-5. System lists all students currently enrolled in that chosen subject under this professor's instruction (including the Ss_Id discriminator):
-{{{
-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 and Ss_Id.
+3. Administrator locates the target enrollment record and clicks the "Edit" button next to it.
+4. System presents the "Enroll Student / Edit Enrollment" web form pre-filled with the existing enrollment details.
 
-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 using the full composite primary key and correct ENUM value:
+[[Image(edit_enrollment_form.png, 800px)]]
+
+5. Administrator inputs or updates the "Final Grade" field (valid values between 6 and 10) and updates the "Status" dropdown to 'Passed' (or 'Completed').
+6. Administrator clicks the "Save Record" button.
+7. System executes the parameterized SQL update statement to persist the updated grade and status:
 {{{
 UPDATE Student_Subject
 SET Final_Grade = ?, Status = 'Passed'
-WHERE Student_Id = ? AND Subject_Id = ? AND Ss_Id = ?;
+WHERE Ss_Id = ?;
 }}}
-8. System displays a confirmation text message indicating that the grade was successfully assigned.
 
-== Implementation Screenshots ==
-[[Image(assignGrade1.png, 800px)]]
-[[Image(assignGrade2.png, 800px)]]
-[[Image(assignGrade3.png, 800px)]]
-[[Image(assignGrade4.png, 800px)]]
+8. System redirects back to the "Student Subject Enrollments" page showing the updated grade and status in the table.
+
+[[Image(enrollment_table.png, 800px)]]