WE WRITE CUSTOM ACADEMIC PAPERS

100% Original, Plagiarism Free, Tailored to your instructions

Order Now!

due on sunday

Want create site? Find Free WordPress Themes and plugins.

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 enable you 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 hereto 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 as follows:
      • For 64-bit operating systems:  copy the files into the folder:C:/Program Files/Microsoft SQL Server/MSSQL11.SQLEXPRESS/MSSQL/DATA
      • For 32-bit operating systems:  copy the files into the folder:C:/Program Files (x86)/Microsoft SQL Server/MSSQL11.SQLEXPRESS/MSSQL/DATA
      • The folder listed above will already exist.  This is where you installed the SQL software to in DB1.
      • When trying to open the DATA folder, you may receive a message about concerns on accessing the folder.  Click ‘continue’ or ‘ok’
    • After the files are saved, the database needs to be attached.
      • Open Microsoft SQL Server Management Studio.  In the Object Explorer window, right click on Databases, and select Attach.
      • On the Attach Databases window, click the Add button.
      • The Locate Files window will default to the DATA folder, where you just copied the files to.  Select the AdventureWorksLT2012_Data.mdf file and click OK.
      • Back in the Attach Databases window, just click OK.
      • The AdventureWorksLT2012 database will now display in Object Explorer under Databases. 
  • 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.

Please submit your assignment.

For assistance with your assignment, please use your text, Web resources, and all course materials.

Reference

Code Plex. (2012). AdventureWorks Databases – 2012, 2008R2 and 2008. Retrieved from http://msftdbprodsamples.codeplex.com/releases/view/93587

Grading Rubric

Our Service Charter

  1. Excellent Quality / 100% Plagiarism-Free

    We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers.

  2. Free Revisions

    We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed.

  3. Confidentiality / 100% No Disclosure

    We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service.

  4. Money Back Guarantee

    If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit.

  5. 24/7 Customer Support

    We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.
Excellent Quality
Zero Plagiarism
Expert Writers

Order Now or Free Quote
Did you find apk for android? You can find new Free Android Games and apps.

Instant Quote

Subject:
Type:
Pages/Words:
Single spaced
approx 275 words per page
Urgency (Less urgent, less costly):
Level:
Currency:
Total Cost: NaN

Get 10% Off on your 1st order!

100% Plagiarism Free Guarantee
We provide hand written, well researched original papers, and run them through best in class plagiarism detectors to ensure that you receive 100% original work.
24/7 Support
We are available to take orders and answer an queries round the clock. We are awake when you are. Our superior custom writing service knows no timezone!
Deadlines
We are crazy about deadlines. We want to hit them all the time. And we do! You don't need to worry about when your paper is due, we handle deadlines as thin as 3 hours and as broad as 3 months.
Confidentiality
A custom paper made for you is strictly yours. We ensure that your persona is protected, together with all the details pertaining to your custom essay paper. It will not be reused or distributed online.

© 2017 EssayMatrix.com|Prime Research Inc.