Practice Problem 2: Database Setup, due Thursday, 8/31

Objective: To get a database setup and ready to use in VS.NET

For this assignment you should do the following:
  1. Before you start this assignment, you must have SQL Server or the MSDE installed and running on your computer.
  2. Use Visual Studio .NET to create a new Database Project (or interface directly with SQL Server if you wish).
  3. Download the scripts for the Novelty database from your book and unzip the file after you download it.
  4. Load all the SQL Scripts that were in the ZIP file.
  5. Run the scripts in the order specified in ReadMe.txt
  6. Create a new query to select all fields from all records from tblOrder with ID < 300, with the results sorted by ID. Run this query.
  7. Turn in your query results, either by copying them into an e-mail or by printing them out.

Return to main CS 112D page