A full-stack project with a PHP/SQL backend and HTML/JS frontend. Created a schema for a relational database that runs on Oracle DBMS, and a frontend for users to access and modify the database.
Home Page
The image below shows an example usage of the home page that general users will use. This particular instance demonstrates a user requesting a list of galaxies with a size greater than 60,000.
Admin Page
The image below shows what the admin user page looks like. This allows admins to make changes to the database, including Adding, Updating, Removing, and Viewing all the data.
Here is an example of The entire Galaxy data table on the Oracle server that was used in the query from earlier, as seen on the admin page:
For the backend, we first had to develop An ER diagram to visualize the relational database we would be creating:
This ER diagram was then converted to a relational model, where it was normalized using BCNF to reduce data redundancy. Details for this are in the Relational Database Design directory