SQL installation

Task 1 ◦Click hither to download and inaugurate the AdventureWorks LT2012 postulatesbase into the SQL environment. Unzip the improve and ammunition the postulates improve and the log improve into the Postulates folder amid the folder Program Files (x86)/Microsoft SQL Server as follows: ◾For 64-bit clear systems:  copy the improves into the folder: C:/Program Files/Microsoft SQL Server/MSSQL11.SQLEXPRESS/MSSQL/DATA  ◾For 32-bit clear systems:  copy the improves into the folder: C:/Program Files (x86)/Microsoft SQL Server/MSSQL11.SQLEXPRESS/MSSQL/DATA  ◾The folder listed overhead conciliate already halt.  This is whither you inaugurateed the SQL software to in DB1.  ◾When obscure to unreserved the DATA folder, you may entertain a missive about concerns on accessing the folder.  Click ‘continue’ or ‘ok’  ◦After the improves are saved, the postulatesbase needs to be robust. ◾Open Microsoft SQL Server Management Studio.  In the Object Explorer window, lawful click on Databases, and choice Attach.  ◾On the Attach Databases window, click the Add nonentity.  ◾The Locate Files window conciliate omission to the DATA folder, whither you honorable copied the improves to.  Select the AdventureWorksLT2012_Data.mdf improve and click OK.  ◾Back in the Attach Databases window, honorable click OK.  ◾The AdventureWorksLT2012 postulatesbase conciliate now vault in Object Explorer underneathneath Databases.    •Task 2 ◦Generate a postulatesbase diagram for all the consultations in the postulatesbase. ◾Include a screenshot of this diagram in your Word muniment.    •Task 3 ◦Write SELECT declarations for the aftercited questions: ◾For each of these declarations, enclose a screenshot of the SQL declarations and results. Make fast to enclose the declaration deed, including the resulting postulates. 1.Display all posts and all rows from the Customer consultation.  2.Display the ProductID, ProductNumber and ListPrice for all rows in the Product consultation.  3.Modify question 2 so that the post headings are as follows: ◾"ID," "Number," and "List Price"   4.Display the CustomerID, liberal customer designate, and Crew Designate for all customers in the Customer consultation. The liberal customer designate would be appearancen by vaulting the values partially from the expedient posts. Another optional, and over past, vestibule to appearance liberal customer designate would be to cohere the expedient posts and friend an alias.  5.Display the CustomerID, liberal customer designate, and Crew Designate for all customers in the Customer consultation. ◾Name the posts "ID," "Name," and "Company Name" (respectively), and description the postulates by the crew designate.       Combine all of the screenshots into a unique Word muniment, and present this for grading.