ISC 561
IS DATABASE MANAGEMENT
Fall 2009

 

Syllabus
 Fall 2009

New
Quiz 1 (avi)
Exam 2 (zip)

SQL demos
To open the sql files directly in SQL Server, click "save as" and remove the .txt extension.

Sql Server 2008 step-by-step installation instructions (doc)

SQL script to create the Northwind database (sql) and Pubs database (sql )

Offline version of Race database (zip) with instructions (doc)
 

Brief setup video (avi)
Subqueries:
SELECT (SQL)
    Uncorrelated(avi1, avi2, avi3, avi4, avi5, avi6, avi7, Homework Example)
    Correlated (avi8, avi9, avi10, Homework Example)
FROM (SQL) (avi1, avi2, avi3, avi4)
WHERE (SQL) (avi zip)
GROUP BY (SQL) (avi zip)
HAVING (SQL) (avi zip)
OUTER JOINS (SQL) (avi)
UNION (SQL) (avi)
DIVISION ANY ALL (SQL) (zip)

Old ppt slides illustrating SQL (ppt)

Normalization
Relation, keys, and functional dependencies (SQL)(zip)
Tokenized tables (Daigle, 1997) (ppt) (zip1)(zip2)(zip3)
Denormalization (zip)
In-Class Normalzation problems (zip)

ERD Modeling
  Itemized List Template (doc)
  ERD example: eBay (doc)
  Chapter 5 (zip)
  Itemized list (zip)
  eBay ERD example (zip)
  TimeSheet example (zip)
  Advising sheet example (zip)

AMCIS example
  Problem statement (zip)
  ERD (zip)
  CREATE TABLE (sql) (zip)
  Enforce constraints (sql) (zip)
  Sample data  (sql) (zip)
  Max and Min Cardinality constraints  (sql) (zip)
  PPT slides for chapters 6 and 7 (zip)

Triggers and Row Level Audit tables  (sql) Audit tables: (link)
  Inserted and deleted buffers (zip)
  Triggers overview (zip)
  Audit tables intro (zip)
  Row Level Audit Tables (zip)

Managing Multiuser databases (sql) (ppt)
  Intro (zip1)(zip2)(zip3)
  Lost update (zip)
  Uncommitted data (zip)
  NonRepeatable read (zip)
  Deadlock (zip1)(Zip2)

Indexes (sql) (zip1) (zip2) (zip3)
  Clustered versus nonclustered (doc)
  Questions (doc)

VIEWS (sql)(zip)


Cursors and Temporary tables (sql)

Homework
 

Course project
 Specifications (doc)
SQLexerciseSystem
Login
 

Link to last semester's materials