Changes between Version 2 and Version 3 of UC3001

Timestamp:

06/15/26 14:16:44 (4 days ago)

Author:

216009

Comment:

--

UC3001

@@ -3 +3 @@
 **Initiating actor:** Student
 
-**Other actors:** Professor
+**Other actors:** None
 
 **Description:**
-A student wants to enroll in a subject offered by their faculty. The system checks prerequisites, enrollment limits, and records the enrollment in the database.
+A student enrolls in a subject offered by their faculty and selects a specific professor who teaches that course instance.
 
 **Scenario:**
@@ -12 +12 @@
 1. Student logs into the system and selects “Enroll in Subject.”
 
-2. System displays a list of subjects available for their faculty:
+2. System displays available subjects and the professors teaching them at the student's faculty:
 {{{
-SELECT s.Id, s.Name, s.Semester, s.Credits 
-FROM Subject s 
-JOIN Faculty f ON s.Faculty_Id = f.Id
-JOIN Student st ON st.Faculty_Id = f.Id
+SELECT s.Id AS Subject_Id, s.Name AS Subject_Name, p.Id AS Professor_Id, p.Name AS Professor_Name, p.Surname AS Professor_Surname
+FROM Subject s
+JOIN Professor p ON p.Faculty_Id = s.Faculty_Id
+JOIN Student st ON st.Faculty_Id = s.Faculty_Id
 WHERE st.Id = :student_id;
 }}}
 
-3. Student chooses a subject and clicks “Enroll.”
+3. Student chooses a subject and the desired professor, then clicks “Enroll.”
 
-4. System checks if the student is already enrolled:
+4. System checks if the student is already enrolled in this subject:
 {{{
 SELECT * FROM Student_Subject
@@ -29 +29 @@
 }}}
 
-5. If not enrolled, system inserts enrollment record:
+5. If not enrolled, system inserts the enrollment record:
 {{{
-INSERT INTO Student_Subject(Student_Id, Subject_Id, Status, Enrollment_Date, Absences_Count) 
-VALUES (:student_id, :subject_id, 'ENROLLED', CURRENT_DATE, 0);
+INSERT INTO Student_Subject(Student_Id, Subject_Id, Professor_Id, Status, Enrollment_Date, Absences_Count) 
+VALUES (:student_id, :subject_id, :professor_id, 'PASSED', :enrollment_date, 0);
 }}}