College Project
MySQL:Movie Watchlist & Recommendation Tracker
Lucknow
06.2025 - 07.2025
- Designed a relational database to manage personal movie watchlists, ratings, genres, and recommendations.
- Created normalized tables: `Users`, `Movies`, `Genres`, `User_Watchlist`, and `Recommendations`.
- Used JOINs and subqueries to generate custom watchlists, such as "Top-rated Action Movies not yet watched".
- Implemented queries to track each user's watched history, favorite genres, and frequent watch times.
- Practiced SQL techniques like COUNT, AVG, GROUP BY, and DATE filtering for user behavior analysis.
