06-Query-a-Digital-Music-Store-Database

Query a Digital Music Store Database

Contents
Project Description
Database ERD
Questions
Conclusion
Built with

Project Description:

This project is part of Udacity's Data Analysis Nanodegree Program. In this project, we will query the Chinook Database, a digital music store, w e will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information. The schema for the Chinook Database is provided below.

Database ERD:

Questions:

• Q1: Who is the top customer at Chinook?
• Q2: Who is the best selling artist?
• Q3: What is the most frequent genre in the database?
• Q4: Who is the top rock artist in the database?

Conclusion

These are derived conclusions after completing quering Chinook database.

Q1: Who is the top customer at Chinook?

Helena Holy is our best customer who purchased to Chinook.

Q2: Who is the best selling artist?

Iron Maiden is the best selling artist at Chinook.

Q3: What is the most frequent genre in the database?

Rock appears to be the most frequent genre in Chinook database.

Q4: Who is the top rock artist in the database?

Led Zeppelin is the top rock artist to Chinook.

Built with:

• DB Browser SQLlite
• Python3
• Pandas
• Matplotlib
• Seaborn
• Google Slides