Changes between Version 7 and Version 8 of UseCase3003Implementation

Timestamp:

09/10/26 12:34:44 (7 hours ago)

Author:

216009

Comment:

--

UseCase3003Implementation

@@ -1 @@
-= UC3001 – Enroll in Subject Implementation 
+== UC3001 – Request Consultation and Advice Implementation ==
 
 '''Initiating actor:''' Student
-'''Other actors:''' None
+
+'''Other actors:''' Professor
 
 '''Description:''' 
-Student registers for an available course module matching their faculty division and selects an associated professor who oversees that course instance.
+Student submits a request for dynamic academic consultations and expert advice from a designated professor through the web portal interface.
 
 '''Scenario:'''
-1. System displays the Student Menu interface.
-2. Student selects the option to "Enroll in Subject".
-3. System outputs a full list of registered students, and the user selects their unique Student ID.
-4. System identifies the student's faculty association and filters all valid available subjects:
-{{{
-SELECT s.Id, s.Name 
-FROM Subject s 
-JOIN Student st ON s.Faculty_Id = st.Faculty_Id 
-WHERE st.Id = ?;
-}}}
-Student selects a target Subject ID from the listing.
-
-5. System queries and displays all professors affiliated with the faculty offering that selected subject:
+1. Student navigates to the "Consultations & Advice" section from the Student Dashboard.
+2. System displays the advice request form and queries available professors associated with the student's subjects:
 {{{
 SELECT p.Id, p.Name, p.Surname 
 FROM Professor p 
-JOIN Subject s ON p.Faculty_Id = s.Faculty_Id 
-WHERE s.Id = ?;
+JOIN Teach t ON p.Id = t.Professor_Id 
+WHERE t.Subject_Id = ?;
 }}}
-Student selects a specific Professor ID.
 
-6. System performs an validation check to ensure a duplicate active enrollment does not already exist:
+[[Image(consultation_form.png, 800px)]]
+
+3. Student selects the target Subject and Professor from the dropdown options.
+4. Student fills in the topic details, preferred date, and specific questions/notes for the consultation session.
+5. Student submits the form.
+6. System verifies that no conflicting consultation requests exist for the same timeslot:
 {{{
-SELECT * FROM Student_Subject WHERE Student_Id = ? AND Subject_Id = ?;
+SELECT * FROM Consultation 
+WHERE Student_Id = ? AND Professor_Id = ? AND Scheduled_Date = ?;
 }}}
-7. If no prior enrollment is found, the system saves the record using the baseline registration status:
+
+7. System inserts the new consultation request into the database:
 {{{
-INSERT INTO Student_Subject (Student_Id, Subject_Id, Professor_Id, Status, Enrollment_Date, Absences_Count)
-VALUES (?, ?, ?, 'Enrolled', CURRENT_DATE, 0);
+INSERT INTO Consultation (Student_Id, Professor_Id, Subject_Id, Request_Date, Scheduled_Date, Topic, Status) 
+VALUES (?, ?, ?, CURRENT_DATE, ?, ?, 'Pending');
 }}}
-8. System prints a terminal message confirming that course enrollment completed successfully.
 
-== Implementation Screenshots ==
-[[Image(enrollSubject1.png, 800px)]]
-[[Image(enrollSubject2.png, 800px)]]
-[[Image(enrollSubject3.png, 800px)]]
-[[Image(enrollSubject4.png, 800px)]]
+8. System reloads the page and displays a notification confirming that the consultation request has been successfully scheduled.
+[[Image(consultation_success.png, 800px)]]