Right click on database diagrams

Assignment Help Basic Computer Science
Reference no: EM131293508

Assignment Overview:

Using the classroom discussions last week and the knowledge you gained from last week's tutorials, list the products sold by each Salesperson during the month of January in 2012. In this assignment you will print the relevant ERD, the SQL query, and the query results to PDF files and submit the PDF files to this assignment in Blackboard. You will need the following fields for this query: Salesperson's Sales Quota, Job Title, First Name, Middle Name, Last Name, Sales Order Number, Order Date, and Product Order Quantity, and Product Name. You will need to explore the Database Diagrams to identify the six tables necessary to create this query. You will need to design and query that supplies the required information, and you will need to execute the query you created.

Instructions

1. After opening SQL Server, go to the AdventureWorks database in the left pane, expand the database, right click on database diagrams, click new database diagrams, and explore the ERD for AdventureWorks until you can identify the six tables necessary to develop the query.

2. Right click on AdventureWorks database in the left pane, click new query, then in the new blank window right click and select Design Query in Editor. When the list of tables pop's up, and select the six tables required to design the correct query.

3. Choose the fields identified in the assignment overview and modify the query to only choose data for January 2012 using a "Where" clause and  with a "greater than" and "less than" sign.

4. Execute the query, fix mistakes, and repeat until you get the necessary results.

5. Print the ERD, Query, and Results each to a PDF file that you submit on Blackboard.

Reference no: EM131293508

Questions Cloud

Information security manager for medium-sized software : Suppose that you are currently employed as an Information Security Manager for a medium-sized software development and outsourcing services company.
How you would be a great fit for each position : Write a page describing how you would be a great fit for each position and why each position would match your employment needs.
What is a security policy : 1) What is a security policy? what are the typical elements of a policy? 2) what are security controls and how do they relate to security architecture. Give a specific example.
Write a business proposal for the company-porter 5 forces : Write a business proposal for the Organization:Porter 5 Forces
Right click on database diagrams : After opening SQL Server, go to the AdventureWorks database in the left pane, expand the database, right click on database diagrams, click new database diagrams, and explore the ERD for AdventureWorks until you can identify the six tables necessar..
Explain the deviant actions of the los angeles police : Research and explain the deviant actions of the Los Angeles Police Department's Rampart CRASH until during the late 1990's.
Create the missing section of employee handbook : Describe how Dalman and Lei can create the missing section of employee handbook by describing how the four step control process could be implemented to correct the problem of misreporting hours.
Concept of an association related to that of mobility : How is the concept of an association related to that of mobility? Is a distribution system a wireless network? Discuss and support your claim.
Design a contemporary arts museum and create own exhibition : Design a contemporary arts museum, and create your own exhibition. Pretend that you are a wealthy patron commissioning an architect to design and build a new contemporary arts museum.

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Is this still true when there are no messages in transit

Is this still true when there are no messages in transit?

  Define a two-dimensional array named temp of three rows

Define a two-dimensional array named temp of three rows and four columns of type int such that the first row is initialized to 6, 8, 12, 9; the second row is initialized to 17, 5, 10, 6; and the third row is initialized to 14, 13, 16, 20.

  Selection of right type of compensation agreement

How can the selection of the right type of compensation agreement save money?

  Calculate the dollar rates of return on the following assets

A £10,000 deposit in a London bank in a year when the interest rate on poundsis 10 percent and the $/£ exchange rate moves from $1.50 per pound to $1.38per pound.

  Ways to send these postcards to friends

There are k types of postcards, each with limited amount. Let there be ai copies of i-th postcard. How many ways are there to send these postcards to n friends?

  What is the pmf of c the cost of the phone for one month

hat is the PMF of C, the cost of the phone for one month

  Draw the lattice of cuboids

Draw the lattice of cuboids

  Component of the creating a scene view

Clipping algorithms are an important component of the creating a scene view. Explain why clipping is necessary. Choose an example of a boundary and a line and show how the endpoints of the clipped line can be calculated.

  Discuss backup plans and any devices that you use

In this week's discussion, discuss what you think you should do to protect your work on the computer. Discuss backup plans and any devices that you use for the backup of your information.

  Determine the horizontal force developed on the board

The clamp provides pressure from several directions on the edges of the board.

  Formulate this problem as a minimum cost flow problem

Formulate this problem as a minimum cost flow problem involving a copy of the given graph for each time period.

  Design a class named rectangle to represent a rectangle

Following the example of the Circle class in Section 9.2, design a class named Rectangle to represent a rectangle. The class contains:

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!

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