UC2001 – Assign Grade to Student Implementation

Initiating actor: Administrator Other actors: Professor

Description: 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. 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 Ss_Id AS ID, Student_Id, Subject_Id, Enrollment_Date, Status, Final_Grade AS Grade, Absences_Count AS Absences
   FROM Student_Subject;
   

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.

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 Ss_Id = ?;
   

8. System redirects back to the "Student Subject Enrollments" page showing the updated grade and status in the table.