Schedulemaster Dashboard
Purpose: Extension of School Project
Project Type: ReactJS, NodeJS, MySQL
Date: Fall 2021
A web interface to access a mock flight school's MySQL database.
Purpose
In our Database class at Seattle University, we were split into groups to make a database for some mock business. Our group chose to do a flight school. We were supposed to use a provided Java program named Queryrunner which allowed users to run various queries through a GUI, but I chose to create a web interface instead, as well as provided some additional functionality.
A walkthrough
Basic functions analogous to those found in the provided Queryrunner program to simply query and return results are found in the Sample Queries section of the navbar. Results are simply returned as a table representing the MySQL backend's response.
Additional functionality beyond the provided Queryrunner program were added. One such function is viewing aircraft recommended to a specific customer ID based upon various individual factors, as well as being able to create a reservation which would then be added to the MySQL database. Another function was further processing of the returned database data into a simple graph, which was made with D3.
