College - Author 1

College of Engineering

Department - Author 1

Computer Engineering Department

Degree Name - Author 1

BS in Computer Engineering

College - Author 2

College of Liberal Arts

Department - Author 2

Liberal Arts and Engineering Studies Program

Degree - Author 2

BS in Liberal Arts and Engineering Studies

Date

6-2026

Primary Advisor

April Grow, College of Engineering, Computer Science and Software Engineering Department

Abstract/Summary

The Los Banos Martial Arts Academy communicates with its families through a combination of Instagram messages, WhatsApp group chats, emails, and phone calls that leads to missed messages and an unprofessional experience, made worse by an audience of parents who are not comfortable with technology. This project designed and built a centralized web platform that doubles as the academy’s public marketing site and as a private portal for enrolled families. The system uses invite-only, passwordless magic-link login, enforces structured communication rules that allow family-to-staff and group messaging but block private parent-to-parent messaging, and keeps a non-destructive data model so deactivating an account preserves its history. It is built as a React single-page application backed entirely by Supabase, which provides PostgreSQL, authentication, storage, real-time updates, and server-side logic. The completed MVP supports announcements, a parent blog, private and group messaging, student profiles, instructor test-day feedback, public reviews, and a full enrollment pipeline that carries an anonymous trial request through admin approval, token-based self-scheduling against a recurring availability calendar, confirmation, and automated email reminders. Security rules were pushed down into the database through Row Level Security and remote procedure calls so they hold even if the interface is bypassed. The system was validated through ongoing informal feedback from anonymous user tests and the client.

Share

COinS