Project 3 of the Udacity Data Foundations Nanodegree (DFND)
In this project, you will query the Chinook Database. The Chinook Database holds information about a music store. For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information. To assist you in the queries ahead, the schema for the Chinook Database is provided below. You can see the columns that link tables together via the arrows.
- SQL Queries
- Presentation
- Submission Phase
SQL Queries:
The student can write error-free SQL queries.
- All SQL queries run without errors and produce the intended results.
The student can use joins correctly in SQL queries.
- Each SQL query needs to include one or more explicit join. The JOIN or JOINs should be necessary to the query. If a question does not require a JOIN please change the question to be one that does.
The student can use aggregations correctly in SQL queries.
- Each SQL query needs to include one or more aggregation. This could be a COUNT, AVG, SUM, or other aggregation.
Student can answer multiple questions by using SQL
- The student has used at least 4 unique SQL queries in their submission.
Presentation:
The student’s slides are organized well and are easy to read and understand.
- Each slide should have an appropriate title and the visualization descriptions should be free of significant factual, spelling and grammar mistakes.
The student can create data visualizations that provide useful information.
- All visualizations should make logical sense and provide accurate information about the indicated area.
The student can format data visualizations clearly and make good use of labeling.
-
All visualizations include a title and axis labels, have a legend where applicable, and are easily understood.
-
Every visualization should have: chart title, x axis title, x axis labels, y axis title, y axis labels
Submission Phase:
The student has uploaded all files necessary for review.
- A PDF report has been uploaded and a .txt file with the queries has been uploaded in a single zipped folder file.