Reference no: EM131296031
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.
|
Cultural change and project sponsorship
: Examine the primary reasons why project management causes a cultural change and the impact of that change on integrative information technology. Support your response with at least one (1) example of a cultural change that project management can c..
|
|
Medium-sized software development
: Suppose that you are currently employed as an Information Security Manager for a medium-sized software development and outsourcing services company.
|
|
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.
|
|
Discuss how a companys culture can affect its quality
: The CEO of your firm has heard from several of his peers in town that major new quality initiatives almost always require some kind of culture change.Discuss how a company's culture can affect its quality performance from both a positive and negati..
|
|
Database in the left pane
: 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..
|
|
Discuss how the research might help solve the problem
: Discuss how the research might help solve the problem. Describe the business research process followed in the study. Identify the research problem, the research design approach, and research method used.
|
|
Calculate the sine and cosine functions of different angles
: Write the first four terms of the Taylor expansion of the following function near the point x- Write a program to calculate the sine and cosine functions of different angles based on the Taylor expansion.
|
|
Given the answer of the multiple choice questions
: Given the answer of the multiple choice questions:In a one-tailed hypothesis test, a critical point is a point that divides the area under the sampling distribution of a,A two-tailed hypothesis test contains.
|
|
How does your organization inspire and engage employee
: How does your organization inspire and engage both employee and customer participation in regards to your social responsibility initiatives?
|