rsvp-movies-sql-case-study

RSVP Movies SQL Case Study

An in-depth case study analyzing the RSVP Movies dataset using MySQL and SQL queries to explore insights and trends in the movie industry.

Project Overview

This repository contains resources and scripts for setting up and analyzing the IMDB-style database for RSVP Movies. The project includes SQL queries, database setup scripts, and an executive summary of findings.

Repository Structure

The repository is organized as follows:

I. IMDB-Setup

• Table Setup
• Movie Table
• Genre Table
• Director Mapping Table
• Role Mapping Table
• Names Table
• Ratings Table

II. Insights using SQL queries

III. Case Study

Setup Instructions

Follow the steps below to set up the IMDB database for analysis:

1. Install MySQL

• Download and install MySQL Server from the official MySQL website.

2. Database Setup - Use IMDB-Setup scripts

3. Run Queries from Insights-using-queries.sql

Execute the analysis queries from the Insights-using-queries.sql file to explore trends and insights.

Technologies Used

• Database: MySQL, Oracle23ai - Autonomous Database
• Scripting: SQL
• VSCode to Connect to MySQL and Oracle23ai and execute the queries
• Documentation: Markdown, PDF

Contact

For any questions or collaboration:

Vikash Tripathi, Vimal Nelson, Vijay Mahawar