Changes between Version 4 and Version 5 of UC3001

Timestamp:

09/09/26 13:07:16 (29 hours ago)

Author:

216009

Comment:

--

UC3001

@@ -12 +12 @@
 1. Student logs into the system and selects “Enroll in Subject.”
 
-2. System displays available subjects and the professors teaching them at the student's faculty:
+2. System displays available subjects offered by the student's faculty and the professors assigned to teach them:
 {{{
 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 Teach t ON t.Subject_Id = s.Id
+JOIN Professor p ON p.Id = t.Professor_Id
 JOIN Student st ON st.Faculty_Id = s.Faculty_Id
 WHERE st.Id = :student_id;
@@ -31 +32 @@
 5. If not enrolled, system inserts the enrollment record:
 {{{
-INSERT INTO Student_Subject (Ss_Id, Student_Id, Subject_Id, Professor_Id, Status, Enrollment_Date, Absences_Count) 
+INSERT INTO Student_Subject (Ss_Id, Student_Id, Subject_Id, Professor_Id, Status, Enrollment_Date, Abesense_Count) 
 VALUES (:ss_id, :student_id, :subject_id, :professor_id, 'Enrolled', :enrollment_date, 0);
 }}}