Full-Stack Film Rental Management System
TA-NK Films is a full-stack film rental store management system built as a paired CS490
course project. It simulates the operations of a real video rental store using the classic
Sakila MySQL sample database, which models film inventory, customer records, and rental
transactions across a realistic relational schema.
I designed and implemented the complete customer management system on the backend, writing
Flask API endpoints to list, add, edit, and soft-delete customers, with a safeguard that
blocks deletion when active rentals exist. I also built the rental transaction endpoints,
handling both rent and return operations with full SQL transaction management and rollback
on error. The film search endpoint was another area I owned, supporting partial matching
by title, actor name, or genre, as well as a customer details view that surfaces full
rental history. Parameterized queries are used throughout all of my endpoints to prevent
SQL injection.
On the frontend, I implemented the edit and delete customer workflows, fixed error
message handling, and built the live inventory availability update that refreshes film
copy counts via JavaScript without a full page reload. I also handled pagination styling
and typography to keep a consistent look across the application.