Movies Database - A SQL Project

This SQL project is a showcase of my SQL knowledge as is portains to being able to create databases and being able to retrieve information from said databases.

This database holds a small amount of data gathered from IMDB and RottenTomatoes regarding movies, their actors, their directors, and their reviews. The database holds 6 tables - Actors, Directors, Films, Actors_In_Films, Directors_Of_Films, and Reviews. Actors and Directors holds the first and last name of the actor or director, their date of birth, and an actor/director id. The primary key of Actors and Directors is their id and a unique is on the first name, last name, and date of birth. Films holds the title of the movie, the movie's release date, the movie's genre, the movie's budget, and a film id. The primary key is on the film id and there is a unique id on the movie's title, genre, and release date. Reviews contains a rating, a review, and a revew id. There is a primary key on the review id and no other keys. The Actors_In_Films and Directors_Of_Films tables are there simply because multiple actors can be in the same movie and multiple directors can direct multiple movies and this was the simplist way to represent that.

To view each table in the Movies database and some example SQL Queries, click here.