How many unique customers does this music store have

Assignment Help Database Management System

Reference no: EM133743754

Homework: Analyzing the Chinook Database and the Manager Promotion Project

For the questions in this homework, you will use SQLiteStudio to analyze a database. Take screenshots of your SQL code as well as of the results (can be in the same screenshot)

I. Download SQLiteStudio from (sqlitestudio.pl)

II. Download the Chinook database from the SQLite tutorial.

III. Find the structure of the ‘customers' table by double clicking on the table name. Which column is the primary key of the table?

IV. How many unique customers does this music store have?

V. How many states do the customers come from? Is there any missing data?

VI. Now let's examine the available invoices. How many invoices does each customer have?

VII. Which customer (first and last name, please) has spent the most at the music store?

VIII. Return the First name, Last name, address, city, and email for all customers who has no purchases (i.e., no invoices). If there are no such customers, return a table with these columns with blank rows.

IX. What is the most popular genre of music sold at the music store (measured by total number of tracks sold)?

X. We need to promote 1 current employee to Sales manager within the store. Who should it be? Use the data available in the database to develop a way to measure the best candidate for the job and then make a recommendation.

Write out a plan to complete the analysis on the manager promotion. How will you decide this? What measure of success will you use? Use SQL and Python to complete task 1.1 and recommend an employee for promotion. Provide explanation and steps in question X.

Reference no: EM133743754

Questions Cloud

How the food we eat affects the environment : How the food we eat affects the environment. You can make something like, how to reduce food consumption or carbon footprint, etc.

Describe the role and function of law and policy : CYB106 Cybersecurity Policy & Law, Australasian Academy of Higher Education - Reflective journal - Describe the role and function of law and policy

Explain why each term is significant to ethical leadership : Explain why each term is significant to the ethical leadership of a multi-cultural workforce. Identify the strengths, weaknesses, threats and opportunities.

Identify difference and similarity about ethical leadership : Identify 1 difference and 1 similarity about ethical leadership. How would each impact Company XYZ's decision to expand to Mexico?

How many unique customers does this music store have : How many unique customers does this music store have? How many states do the customers come from? Is there any missing data?

How does the work of each artist relate to the issues : How does/did the work of each artist relate to the issues covered in the chapter? Does their work address social justice or question the status quo?

Reflection on case study - community mental health service : Reflection on Case Study - Community Mental Health Service - You need to do the reflection on Possible Consequences of Various Decisions for All Stakeholders

What health outcomes result from your problem : NR449 Evidence-Based Practice Matrix, Chamberlain University - Apply research principles to the interpretation of the content of published research studies

Create at least four different constructors for the class : IT 232 Saudi electronic university- Each product class have a name, an ID, a description, and a price. Create at least 4 different constructors for the class.

User Account

All Pages