Rockbuster Stealth LLC is a movie rental company that is planning to launch an online video rental service in order to stay competitive. This repository contain SQL queries used to acquire a good understanding of the data from inventory, customer insight, and payment departments to develop launch strategy for their new service.
- An entity relationship diagram (ERD) was created to illustrate the relationships between the tables in Rockbuster's relational database.
- A data dictionary was created to catalogue the database's metadata.
- Data check and cleaning procedures before conducting analysis.
- Various types of SQL queries applied such as use of joins, subqueries, CTEs, and CASE statements to answer business questions.
Rockbuster relational database contains data including films, inventory, stores, customers, and payments.
PostgreSQL: 14.1
Amy Yip