WHO CAN DO THIS ASSIGNMENT. 2

For this assignment, there is a link and there is software that you might need to have if you need it .  http://msftdbprodsamples.codeplex.com/releases/view/93587. The assignment is below and it is due my tomorrow 4/3/2016. before 10pm CST time. I am in Dallas, TX. The amount is $20.00

A SQL server was installed during unit 1. The installation included SQL Server Management Studio Express. This tool is used to create and manage your database. The next step is to ensure that the installed software was configured correctly. An existing database is available for this purpose. Using an existing database will also enableyou experiment with querying a database.

For this project, you will access a database to ensure your software was installed and configured properly. You will explore the SELECT statement by populating the tables with data and retrieve the data from the database tables.

• Task 1
  • Click here to download and install the AdventureWorks LT2012 database into the SQL environment. Unzip the file and store the data file and the log file into the Data folder within the folder Program Files (x86)/Microsoft SQL Server/MSSQL11.SQLEXPRESS/MSSQL/DATA .
    • Choose the appropriate file based on whether you are running SQL Server 2012 or 2008.
    • If you installed the 64-bit SQL Server,  the data folder is located in the Program Files/Microsoft SQL Server/MSSQL11.SQLEXPRESS/MSSQL/DATA
• Task 2
  • Generate a database diagram for all the tables in the database.
    • Include a screenshot of this diagram in your Word document.
• Task 3
  • Write SELECT statements for the following questions:
    • For each of these statements, include a screenshot of the SQL statements and results. Make sure to include the statement execution, including the resulting data.
      1. Display all columns and all rows from the Customer table.
      2. Display the ProductID, ProductNumber and ListPrice for all rows in the Product table.
      3. Modify query 2 so that the column headings are as follows:
         • "ID," "Number," and "List Price"
      4. Display the CustomerID, full customer name, and Company Name for all customers in the Customer table. The full customer name would be shown by displaying the values separately from the necessary columns. Another optional, and more advanced, approach to show full customer name would be to combine the necessary columns and associate an alias.
      5. Display the CustomerID, full customer name, and Company Name for all customers in the Customer table.
         • Name the columns "ID," "Name," and "Company Name" (respectively), and sort the data by the company name.

Combine all of the screenshots into a single Word document, and submit this for grading