Name: SUPER TUTOR
Uploaded: 2022-12-07
Duration: 5 min 1 s
Description: SUPER TUTOR. Isabelle George, Justin Han, John Liu, Vatsal Mistry.

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

Scene 1

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.. 

Scene 2

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. 

Scene 3

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. 

Scene 4

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.. 

Scene 5

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.. 

Scene 6

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.

Update Student Information
Student Profile
First N
Last Nune•_
Email :

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. 

Scene 7

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.. 

Scene 8

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.. 

Scene 9

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. 

Scene 10

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. 

Scene 11

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

Database
bhx
Curent Capa:ny-. 1
Date-2022-12-C6
Duatim: I I-burs

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.. 

Scene 12

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. 

Scene 13

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

Reviews:
Name dan mack
Revéw '*eat Tutor
Name Rick Kade
Revéw They are
None dan mack

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.. 

Scene 14

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. 

Scene 15

ExpandedClasses Class and Tutor information Justin: Admin to view all classes John: Student wants to see a tutor’s classes ExpandedReviews Review, Student, and Tutor information Vatsal: Student wants to see a tutor’s reviews Isabelle: Admin wants to filter reviews by student or tutor

[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. 

Scene 16

IndexEnrollments Enrollments Table: Student_ID column Justin: Current student classes John: Find which class capacities need to be decremented when deleting user IndexReviews Review Table: Tutor_ID and Student_ID columns Vatsal: Reviews for a tutor Isabelle: Reviews made by a student

Scene 17

Scene 18

Scene 19

SUPER TUTOR

A view to show all the classes with the information of the tutor teaching it

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

avatar

Used on Student_ID column to speed up queries related to finding enrollments for a specific student

Used on Tutor_ID and Student_ID columns to speed up queries related to finding reviews on a tutor or from a student