SUPER TUTOR

SUPER TUTOR. Isabelle George, Justin Han, John Liu, Vatsal Mistry.

Motivation. Our web application is a tutoring system designed to help students succeed in their classes. Our system enables tutors to host sessions for classes that students may enroll in. For each session, there is a dedicated number of spots available. Each student that attends the session, can review the tutor, based on their satisfaction after the session is complete..

Database and Features. ii;l,. Profile User: Isabelle George Admin: John Liu Schedule User: Justin Han Admin: Vatsal Mistry Item/Experience User: John Liu Admin: Justin Han Comment/Status/Review User: Vatsal Mistry Admin: Isabelle George.

Tech Stack. abstract. Back-end Javascript Front-end HTML CSS Database phpMyAdmin SQL.

USER - Profile (Isabelle). Users include both students and tutors. Both of which can create and manage their account credentials. Users create an account via the homepage by clicking the SIGN UP button. The profile type is selected when the user creates an account. Users may view their profile via the Profile button in the navigation bar..

USER - Profile cont. (Isabelle). Students Profile displays the Student’s first name, last name, and email. The ability to update their information, such as their first and last name, email, and password. The information is updated in the database when the user clicks the Save Modified button..

USER - Profile cont. (Isabelle). abstract. Tutors Profile displays the Tutor’s information: First name, last name, and email Classes tutored (reviews from students) The ability to update their information, such as their first and last name, email, and password. The information is updated in the database when the user clicks the Save Modified button. Note: tutors cannot modify their reviews.

ADMIN - Profile (John). Admins have the ability to delete users (students/tutors) and other admins accounts Which are then removed from the database. Admins can edit users or other admins profile. First Name, Last Name, Email, and Password Admin can add new accounts for users and admins and update those profiles..

USER - Schedule (Justin). Students sign up for sessions to attend. Tutors can open up tutoring sessions at specified time slots To set up a session, tutors will set a max capacity, date, subject being taught, and duration of the class. Students can enroll in a session as long as it’s not at max capacity..

ADMIN - Schedule (Vatsal). Admins can create, delete, and manage the schedule of all sessions. Select drop downs with appropriate error handling. Class is full Student is already enrolled Student is not yet enrolled.

USER - Item/Experience (John). Students can attend multiple different classes and view the preview classes that they have attended Students can also see the different review that were left on the tutor that was teaching the class Tutor can host the session for that class and view the class they have hosted in the past Tutor can see the reviews that were given to them by the students.

ADMIN - Item/Experience (Justin). Admins can create, delete, and manage all session details. Admins will be able to change all details of a session that a class has. This includes the tutor that is teaching the class, the max capacity, the class being taught, date, and duration..

USER - Reviews (Vatsal). Students can review the tutors they attend sessions of. Tutors can receive reviews on their profile from students who attended their sessions. Important Considerations: Tutors cannot delete reviews Student vs Tutor view of a tutor profile Students can only delete their own reviews.

ADMIN - Reviews (Isabelle). Admin are able to view and delete reviews. Admins can filter by tutor or by student. Enter the Tutor ID to view the reviews associated with the tutor, courses they tutored. Enter the Student ID to view the reviews written by the student for the corresponding tutors. Admins can delete reviews via the Delete button..

[Audio] ExpandedClasses A view to show all the classes with the information of the tutor teaching it ExpandedReviews A view to show all the reviews with the information of both the student who left the review, and the tutor that the review is about Need to populate page with tutor information and reviews, so we need both.

[Audio] IndexEnrollments Used on Student_ID column to speed up queries related to finding enrollments for a specific student IndexReviews Used on Tutor_ID and Student_ID columns to speed up queries related to finding reviews on a tutor or from a student.

Demo.

Questions.

Thank You.