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

  Continue funding the olpc program

Explain why you would, or would not, personally donate money to continue funding the OLPC program (assuming you had money to give...).

  Physical evidence collected during an investigation

Physical evidence collected during an investigation should:

  How did demonstrations compare to gerald corey sessions

How did these demonstrations compare to Gerald Corey's sessions with Stan that you watched this week? What similarities and/or differences did you notice.

  Briefly compare and contrast the descriptive components

Briefly compare and contrast the descriptive components of this social policy so that your colleagues will have some understanding of the policy

  Differentiate between global and multicultural education

Read the article titled "Lessons learned from the Indonesia Australia Specialised Training Project, Environmental Law and Enforcement".

  What changes will you implement in your next lesson

ECH-355 - create a lesson plan for ages Birth to Age 8/Grade 3 - What changes will you implement in your next lesson? Be sure to provide specific examples

  Most difficult for a business owner to protect

Explain which intellectual property appears the most difficult for a business owner to protect.

  Write a description and overview of the topic chosen

There have been problems with some clients complaining. Client's rights advocates report there have been many complaints filed in the agency about confidentiality, client dignity, reporting child abuse, and duty to warn issues. They need to have ..

  Crazy airfares case

Is the current airline pricing an example of variable or ?exible pricing? Wh ydid you choose your answer? Should the airlines do anything to passengers who ‘‘jump ship?’’

  Define the possible side effects of the herbal supplement

Would you recommend a herbal supplement in L.L's case? If so, what herbal supplement would he take? What are possible side effects of the herbal supplement?

  Identify concepts that are related to reasoned action model

Identify 2 concepts that are related to the Reasoned Action Model and are illustrated in the description of the competing advertisements.

  Describe the different users of financial statements

F/601/0864-Financial Accounting and Reporting-Pearson BTEC Levels 4 and 5 Higher Nationals in Business- Describe the different users of financial statements.

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