CSCI 4370/6370 Course Materials

Dr. Dan's PowerPoint Presentations

DatePresentation
21-JunTest 1 Solutions

Jeffrey Ullman's PowerPoint Presentations

From CS 415, Stanford University Fall 2004

DatePresentation
21-Jun http://www-db.stanford.edu/~ullman/dscb/pslides/sql1.ppt
23-Jun About indices;
http://www-db.stanford.edu/~ullman/dscb/pslides/sql2.ppt
27-Jun http://www-db.stanford.edu/~ullman/dscb/pslides/host.ppt
29-Jun http://www-db.stanford.edu/~ullman/dscb/pslides/cons.ppt
30-Jun SQL examples: Checks, Assertions, and triggers
5-Jul http://www-db.stanford.edu/~ullman/dscb/pslides/trans.ppt
6-Jul/
7-Jul
http://www-db.stanford.edu/~ullman/dscb/pslides/er.ppt
http://www-db.stanford.edu/~ullman/dscb/pslides/fds.ppt
http://www-db.stanford.edu/~ullman/dscb/pslides/norm.ppt

Practice Exercises

DateExercisesSolutions
22-Jun Queries Solutions
23-Jun Queries Solutions

Test 2 Topics

The test will be held in class on Monday, July 11 and is closed-book.

TopicPoints
JDBC (know the main classes Driver, DriverManager, Connection, Statement, and ResultSet)15 points
Entities and Relations, functional dependency, and normalization15 points
Transactions10 points
Writing SQL queries60 points

Useful Links