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:
- Before you start this assignment, you must have SQL Server or the MSDE installed and running on your
computer.
- Use Visual Studio .NET to create a new Database Project (or interface directly with SQL Server if you
wish).
- Download the scripts for the Novelty database from your book and
unzip the file after you download it.
- Load all the SQL Scripts that were in the ZIP file.
- Run the scripts in the order specified in ReadMe.txt
- 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.
- Turn in your query results, either by copying them into an e-mail or by printing them out.
Return to main CS 112D page