Portfolio Projects Collection (Systems + Databases)

A collection of two distinct academic projects in a single repository, each representing a different area of computer science fundamentals. The first is a disk-based Linear Hash Index implemented in C++. It stores records on disk in 4KB slotted pages, uses a linear hashing scheme to grow the bucket directory dynamically as the load factor increases, and handles overflow chains when individual buckets fill. Binary serialization ensures the index survives restarts. This project required careful bit-level page layout, pointer arithmetic, and understanding of how disk-oriented data structures differ from in-memory ones. The second is a full-stack movie review web application backed by MySQL. The database schema was designed from an ERD, with SQL triggers enforcing business rules and stored procedures handling common operations. The frontend uses Handlebars templates rendered server-side, with forms for browsing, reviewing, and managing movies. Both projects include detailed READMEs with schema diagrams and setup instructions.