ISC 361
Database for Info Systems
Fall 2006

Section 501



Download (MSDNAA) or (here) and install SQL Server 2000 (download and install service packs)
Create an account on the SQL Exercise System.

Order of product demos: Thursday, Friday, Monday, Tuesday

In class demos

Power point slides

Course project
ERD visio, jpg
Entity assignments
Script to insert snuffy and create ValidateUser (sql )

Scripts to create database: common build version 1.1

  1. Create base tables (sql) updated 9/14/2006
  2. Populate base tables (sql)  updated 9/14/2006
  3. Populate student data (sql)  updated 9/14/2006
  4. Updates to tables (sql) (updated October 24, 2006)
  5. Create sprocs (sql) (updated October 24, 2006)
  6. Visual Studio 2005 project files (zip) (updated November 21, 2006)
  7. Avi files (install project) (GridView) (AddEditRole) (AddEditRotation I) (AddEditRotation) (AddEditRotation II )
  8. Crystal Reports (avi)

Templates for defining tables (sql) updated 09/05/2006
Templates for defining log tables and triggers (sql) updated 09/05/2006
Templates for defining views and Instead Of triggers (sql) updated 09/05/2006
Templates for inserting rows into 1:M tables (sql )

ASP.Net online resources
An Extensive Examination of the DataGrid Web Control