Video Game Sales Database Project

This project is a comprehensive Relational Database Management System (RDBMS) designed to analyze video game sales, critic scores, and user ratings. Built with MySQL, the project covers the entire database lifecycle from schema design and normalization to data import and complex analytical querying.

Dataset Information

The data used in this project includes sales figures, ratings, and platform information for thousands of video games.

• Source: Kaggle - Video Game Sales with Ratings
• Link: https://www.kaggle.com/datasets/rush4ratio/video-game-sales-with-ratings
• Content: Game titles, Platforms, Years, Genres, Publishers, Global Sales (NA, EU, JP), Critic Scores, and User Counts.

Database Schema (ER Diagram)

Project Structure

The repository is organized into the following directories:

• sql/: Contains the core SQL scripts, including the full database dump (schema + data) and the analytical queries used for reporting.
• docs/: Contains the project documentation, including detailed reports for Phase 1 (Design) and Phase 2 (Implementation), as well as the project presentation.

Key Features & Analysis

• Data Normalization: Raw CSV data was normalized to eliminate redundancy (e.g., separating Publishers, Genres, and Platforms into distinct tables).
• Complex Queries:
  • Sales trends over the years.
  • Top-performing genres and platforms.
  • Regional sales analysis (NA vs. EU vs. JP).
  • Correlation between Critic Scores and Sales.
• Database Objects: Implementation of Views (e.g., Yearly_Sales) and Stored Procedures for automated reporting.

How to Run

1. Ensure you have MySQL installed.
2. Import the sql/database_dump.sql file using MySQL Workbench or the command line to set up the schema and load the data.
3. Run the queries found in sql/analysis_queries.sql to generate insights.

---

Author: Ismail Ibican Spring 2024