Sneaker Collection Database
A relational database project built for LIS 458: Database Management at Simmons University. The original assignment ran on PHP and MySQL. This live version loads the same schema as a SQLite database in your browser using sql.js, so every query and insert below is real SQL executed against a real database, with no server round-trip.
The schema models a 50-pair personal collection across nine normalized tables: COUNTRY, BRAND, CATEGORY, MODEL, COLOR, COLORTYPE, COLORWAY, COLORMODEL, and the primary SNEAKER table. The interface below lets you browse the gallery, run the canonical search query with user input, insert a new sneaker, run any of the assignment's saved queries, or write your own SQL.
Collection Gallery
All 50 sneakers, drawn live from the SNEAKER table joined to COLORWAY, MODEL, BRAND, and CATEGORY.
Search Records
The original assignment's search form takes user input across brand, model, colorway, category, and notes, then runs a five-table join with parameterized LIKE matching.
Generated SQL
(submit a search to see the query)
Insert a Sneaker
Adds a row to the SNEAKER table. Choose an existing colorway from the dropdown (which is itself populated by a SQL join), enter a size, and an optional condition and note.
Generated SQL
(submit the form to see the query)
Saved Queries from the Assignment
The five queries the original LIS 458 deliverable required, runnable here against the same schema.
Run Your Own SQL
Type any SQL statement. Reads (SELECT) render in a table. Writes (INSERT, UPDATE, DELETE) report rows affected. The database lives in your browser only, so changes do not persist after a page reload.
Schema
Nine tables, third-normal form. SNEAKER is the primary table; everything else is a lookup or junction table.