Unit 2 Database

For this project, you will set up a database and populate the tables with data to explore the SELECT statement and retrieve data from the tables. Ensure that the SQL Server Management Studio is set up and installed.

• Task #1
  • Install the Northwind Database into the environment. Click here to download the database script files.
    • Choose the appropriate file based on whether you are running SQL Server 2012 or 2008.
• Task #2
  • Generate a database diagram.
    • 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. Make sure to include the statement execution, including the resulting data.
      1. Display all columns and all rows from the Employees table.
         • 9 rows returned
      2. Display the regionid, regiondescription for all rows in the Regions table.
         • 4 rows returned
      3. Modify query 2 so that the column headings are as follows:
         • "ID" and "Description"
         • 4 rows returned
      4. Display the customer ID, customer name, and region for all customers.
         • 91 rows returned
      5. Display the customer ID, customer name, and region for all customers.
         • Name the columns "ID," "Name," and "Region" (respectively), and sort the data by the company name.
         • 91 rows returned

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