Task 1
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.