Project Title:

Digital Music Store Analysis

Description:

This project involves creating and managing a SQL database for a music store to solve real-world challenges. The database is designed to efficiently store, retrieve, and manage data related to customers, sales, and inventory. By implementing this system, the store can track customer purchases, manage inventory levels, and generate reports on sales trends.

Tools Used:

SQL, MySQL, PostgreSQL (or any SQL database)

Files:

These datasets are provided by Rishabh Mishra.

Music_Store_database.sql

Gihub Repository:

https://github.com/mdntarif/Digital-Music-Store-Analysis

Entity-Relationship Diagram:

download.png

Task:

Basic:

  1. Who is the senior most employee based on job title?
  2. Which countries have the most Invoices?
  3. What are top 3 values of total invoice?