UseCase2001 – Assign Grade to Student

Initiating actor: Professor

Other actors: Student

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

Scenario:

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

2. System shows subjects the professor teaches:

   SELECT sub.Id, sub.Name, st.Id AS Student_Id, st.Name, st.Surname
   FROM Subject sub
   JOIN Subject_Professor sp ON sp.Subject_Id = sub.Id
   JOIN Student_Subject ss ON ss.Subject_Id = sub.Id
   JOIN Student st ON st.Id = ss.Student_Id
   WHERE sp.Professor_Id = :professor_id;
   

3. Professor selects a student and enters the final grade.

4. System updates the database:

   UPDATE Student_Subject
   SET Final_Grade = :grade, Status = 'COMPLETED'
   WHERE Student_Id = :student_id AND Subject_Id = :subject_id;
   

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