A24 Film Database (SQL)
I developed a relational database documenting over 135 A24 films, each with more than 20 attributes.
The project served as a hands-on application of SQL, data modeling, and automation skills, while offering structured insights into film production, distribution, and audience reception.
Database Design
Built seven interconnected tables covering movie details, languages, awards, crew, ratings, streaming platforms, and budgets.
Established primary and foreign key relationships with constraints to maintain consistency.
Integrated indexing and subqueries to improve query performance and efficiency.
Queries & Automation
Wrote 50+ specialized SQL queries to analyze genres, runtime, IMDb ratings, director counts, filming locations, and more.
Designed 10+ automated stored procedures for retrieving data on budgets, ratings, and release dates.
Created multiple database views to simplify access to complex data sets.
Data Export & Visualization
Exported structured data into JSON format for flexible use across applications.
Designed Tableau dashboards to visualize A24’s performance, including budget trends, genre patterns, and audience ratings.
Challenges Solved
Ensured data integrity through constraints and careful table design.
Optimized query performance with indexing strategies.
Balanced normalization with practical retrieval needs for large datasets.
