User Account

All Pages

Schema for the Chinook Database

Assignment Help Other Subject
Reference no: EM132832253

Introduction

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.

All of the below instructions are discussed in detail as we work through this lesson on your way to completing this project. The below serves as a quick reference of what you will be doing as you progress through the completion of this project.

Instructions

You will need to follow the instructions on the next three concepts to get the Chinook database up and running on your own machine, and check that it is set up correctly. There will be two parts to this project.

1. The first part is a series of questions that will assure you have mastered the main concepts taught throughout the SQL lessons. Though these questions will not be "graded" by a reviewer, they will help you self assess.

2. The second part is a presentation. Similar to the first project, there isn't a 'right answer' for the second portion of the project. You have the ability to be creative in the questions you ask. You will then write a SQL query to pull the data needed to successfully answer your question. Use the pulled data to build a visual (bar chart, histogram, or another plot) that answers your question. The essentials of your project submission are discussed in the next sections.

Attachment:- Project Walkthrough.rar

Reference no: EM132832253

Questions Cloud

Develop plan with your mentor teacher to administer activity : Targeted teaching plans are developed with the use of observational data. It is important to consider a student's level of engagement and motivation.
How much gain or loss does misha recognize : How much gain or loss does Misha recognize, and what is her basis in the distributed inventory and in her partnership interest following the distribution?
What is its debt-to-capital ratio : The firm's total capital is $110 million and it finances with only debt and common equity. What is its debt-to-capital ratio
Contrast the views of management and accountants : Contrast the views of management and accountants regarding the changes required by the Sarbanes-Oxley Act on internal controls
Schema for the Chinook Database : Schema for the Chinook Database is provided below. You can see the columns that link tables together via the arrows - All of the below instructions
Determining organization goals : What factors should you consider in determining an organization's goals? How would you decide which strategic and operational plans to use to achieve your goal
What are the three classes of cyberattacks : What are the three classes of cyberattacks and their effects, according to Zertag? What does Zertag mean when she says that Internet has a "huge attack surface"
What is its accounts receivable balance : Assume that it uses a 365-day year. Baxley Brothers has a DSO of 23 days, and its annual sales are $3,650,000. What is its accounts receivable balance
Explain the human machine interaction issues of autonomous : Explain the Human machine interaction issues of autonomous vehicles. And why are Human machine interaction issues regarded as ethical issues?

Reviews

len2832253

3/18/2021 10:36:47 PM

Please need to use the .zip files then need to follow the instruction attached to do the project and fill the SQL-project-submission-template-1 file attached + answer the quiz questions highlighted

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd