Changes between Initial Version and Version 1 of UC2001

Timestamp:

02/03/26 20:52:42 (3 weeks ago)

Author:

216009

Comment:

--

UC2001

@@ +1 @@
+= 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.