ITCO231 Unit 2 AdventureWorks Database

ITCO231 Unit 2 AdventureWorks Database

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.

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.
Display all columns and all rows from the Customer table.
Display the ProductID, ProductNumber and ListPrice for all rows in the Products table.
Modify query 2 so that the column headings are as follows:
“ID,” “Number,” and “List Price”
Display the CustomerID, full customer name, and CountryRegion for all customers.
Display the CustomerID, full customer name, and CountryRegion for all customers.
Name the columns “ID,” “Name,” and “Region” (respectively), and sort the data by the company name.

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