set up a database and populate the tables with data to explore

For this project, you will set up a database and populate the tables with data to explore theSELECT 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. Clickhere to install the database.
    • Note that this link does link to the SQL Server 2000 Sample Databases, but after downloading it, the ZIP file can be extracted and contained inside the package as a file named "instnwnd.sql." This file can be opened and executed inside of Microsoft SQL Server Management Studio.
• 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 includethestatement 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