Assignment 1

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/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.
      1. Display all columns and all rows from the Customer table.
      2. Display the ProductID, ProductNumber and ListPrice for all rows in the Products 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 CountryRegion for all customers.
      5. 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.