X
Related Skills
Description
I led a two-person project to develop a React application for
scheduling school club events across various locations. The app
featured front-end and back-end validation, authentication for
various roles such as: Admins, Campus Admins, and students. We
utilized JWT for security and SHA-256 for password encryption.
Express APIs were used to call SQL stored procedures, and cookies
were used for validation. Using string cleaning and SQL permissions,
we were able to prevent SQL injection attacks. The database was
built in SQL and normalized to 3rd normal form to prevent data
redundancy and ensure data integrity.
-
Created a React application for scheduling club events at a
school in different locations
-
Utilized 3rd normal form and SQL stored procedures to perform
operations on the database and prevent overlapping events
-
Allowed for 3 types of users, Admins, Campus Admins, and
students to access different features of the app
-
Implemented express APIs to call SQL procedures to populate
information on the page using cookies for authentication