Northwind Database SQL Queries

Availability: In stock

Regular Price: $10.00

Special Price: $8.00

OR

Northwind Database Task 2 Database Diagram

Double click on above image to view full picture

Zoom Out
Zoom In

More Views

Quick Overview

Install the Northwind Database into the environment. Click here 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 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

* Required Fields

Regular Price: $10.00

Special Price: $8.00

Details

Install the Northwind Database into the environment. Click here 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 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

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.