UseCase2001 – Assign Grade to Student

Initiating actor: Professor

Other actors: None

Description: A professor records the final grade for a student enrolled in a subject under their supervision.

Scenario:

1. Professor logs in and selects “Enter Grades.”

2. System shows students and subjects that this specific professor teaches:

   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/subject entry and enters the final grade.

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 = 'PASSED'
   WHERE Student_Id = :student_id AND Subject_Id = :subject_id AND Professor_Id = :professor_id;
   

5. System confirms the update and allows the professor to continue grading other students.