UC3003 – Request Consultation and Advice Implementation

Initiating actor: Student

Other actors: Professor

Description: Student submits a request for dynamic academic consultations and expert advice from a designated professor through the web portal interface.

Scenario:

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 Teach t ON p.Id = t.Professor_Id 
   WHERE t.Subject_Id = ?;
   

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 Consultation 
   WHERE Student_Id = ? AND Professor_Id = ? AND Scheduled_Date = ?;
   

7. System inserts the new consultation request into the database:

   INSERT INTO Consultation (Student_Id, Professor_Id, Subject_Id, Request_Date, Scheduled_Date, Topic, Status) 
   VALUES (?, ?, ?, CURRENT_DATE, ?, ?, 'Pending');
   

8. System reloads the page and displays a notification confirming that the consultation request has been successfully scheduled.