Changes between Version 4 and Version 5 of UseCase3001Implementation

Timestamp:

06/15/26 14:35:17 (38 hours ago)

Author:

216009

Comment:

--

UseCase3001Implementation

@@ -5 +5 @@
 **Other actors:** None
 
-**Description:** Student enrolls in a subject offered by their faculty.
+**Description:** Student enrolls in a subject offered by their faculty and selects a specific professor teaching that course instance.
 
 **Scenario:**
@@ -13 +13 @@
 2. Student selects Enroll in Subject.
 
-3. System lists students → selects student ID.
+3. System lists all students → Student selects their Student ID.
 
-4. System lists available subjects → selects subject.
+4. System lists available subjects for the student's faculty:
+{{{
+SELECT s.Id, s.Name 
+FROM Subject s 
+JOIN Student st ON s.Faculty_Id = st.Faculty_Id 
+WHERE st.Id = ?;
+}}}
+Student selects a Subject ID.
 
-5. System checks enrollment:
+5. System lists all available professors for the chosen subject:
+{{{
+SELECT p.Id, p.Name, p.Surname 
+FROM Professor p 
+JOIN Subject s ON p.Faculty_Id = s.Faculty_Id 
+WHERE s.Id = ?;
+}}}
+Student selects a Professor ID.
+
+6. System checks if the student is already enrolled in this subject:
 {{{
 SELECT * FROM Student_Subject WHERE Student_Id = ? AND Subject_Id = ?;
 }}}
 
-6. If not enrolled, system inserts:
+7. If not enrolled, system inserts the new enrollment record into the database:
 {{{
-INSERT INTO Student_Subject(ssId, Student_Id, Subject_Id, Status, Enrollment_Date)
-VALUES (?, ?, ?, 'ENROLLED', CURRENT_DATE);
+INSERT INTO Student_Subject(Student_Id, Subject_Id, Professor_Id, Status, Enrollment_Date, Absences_Count)
+VALUES (?, ?, ?, 'PASSED', CURRENT_DATE, 0);
 }}}
 
-7. System confirms enrollment.
-[[Image(enrollSubject1.jpg, 800px)]]
+8. System confirms successful enrollment.
 
+[[Image(enrollSubject1.png, 800px)]]