The given project is a MySQL project, I have used RSVP movies database to derive insightful results using all kinds of SQL queries right from Basics to Advance SQL for RSVP movie company and help them to find to the top genre, director and actor for their next project.
RSVP Movies is an Indian film production company that has produced many super-hit movies. The company has generally released movies for the Indian audience, but they plan to release a movie for the global audience in 2022.
The production company wants to plan every move analytically based on data and has approached you for help with this new project. You have been provided with the data of the movies that have been released in the past 3 years. You have to analyse the data set and draw meaningful insights to help the company start their new project.
Analyse the data of RSVP movies to gain insights on the different factors that affect the movies . This is undertaken as an individual project.
1 Download the IMDb dataset. 2 The first tab contains the ERD and the table details. Study that carefully and understand the relationships between the table. 3 Inspect each table given in the subsequent tabs and understand the features associated with each of them. 4 Open your MySQL Workbench and start writing the DDL and DML commands to create the database. 5 If you don't wish to perform the data loading part, you can directly download the SQL script file containing all the commands and data required for the database creation and start directly with the querying.