CS 365: Database Systems
Fall 2007

Instructor: Alexander Dekhtyar, dekhtyar@csc.calpoly.edu, 14-209

Office Hours:

When		Who	Where
Monday		Alex	14-209
Tuesday	11:00am - 12:00pm	Alex	14-209
Wednsday	9:00am - 12:00pm	Alex	14-209
Thursday	11:00am - 12:00pm	Alex	14-209

Additional appoinments: send email.

News and Notes

• Finals Week Office hours:
  

  Tuesday:	by appointment. Email me in advance.
  Wednsday:	hours TBA - most likely late morning-early afternoon
  Thursday:	10:30am - 12:00pm

  
  [November 29, 2007]

• Final Exam: you are allowed to use a cheat-sheet a single letter-sized pice of paper filled with any information of your choice.
  [November 29, 2007]

• Lab 8 can be submitted by early morning, Saturday, Dec 1.
  [November 29, 2007]

• Results for Lab 6 queries are now available below. Note, for CARS dataset, there are two possible "correct" answers for the first two queries - if points were deducted for either of the anwers, please notify me, the points will be restored.
  [November 27, 2007]

• The dataset for Lab 8, AIRLINES is now available.
  [November 19, 2007]

Course Materials

Labs

Lab 1, Part 1	Due: September 25	: Why databases?	Postscript	PDF
Lab 1, Part 2	Due: September 27	: Why databases?	Postscript	PDF
Lab 2	Due: October 9/ October 4 (early bird special)	: SQL DDL, DML, SQL*plus	Postscript	PDF
Lab 3	Due: October 11	: SQL DDL, DML, SQL*plus	Postscript	PDF
Lab 4	Due: October 16	SQL: simple queries	Postscript	PDF
Lab 4: Part 2	Due: October 23	SQL: simple queris	Postscript	PDF
Lab 5:	Due: October 25 (no submission needed)	SQL	Postscript	PDF
Lab 6:	Due: November 6	SQL	Postscript	PDF
Lab 7:	Due: November 15	JDBC	Postscript	PDF
Lab 8:	Due: November 29	PL/SQL	Postscript	PDF

Lab Data

Lab 1: Part 1	students.txt		[September 10, 2007]
Lab 1: Part 2	list.txt	teachers.txt	[September 25, 2007]

Lab Tests

Lab 1:	Public Test Suit	Script for Java implementations	Results	[September 11, 2007]
Lab 1	Private Test Suit	script		[October 1, 2007]
Lab 1, part 2	Private test suit	script		[October 1, 2007]
Lab 2	expected results for part 3	For STUDENTS dataset	For BAKERY dataset	[October 2, 2007]
Lab 2	Test scripts	STUDENTS dataset	BAKERY dataset	[October 5, 2007]
Lab 2	Test scripts	CSU dataset	CARS dataset	[October 5, 2007]
Lab 4	Tuple counts	BAKERY dataset	CSU dataset	[October 23, 2007]
Lab 4	Tuple counts	Final Tuple count: all datasets		[November 15, 2007]
Lab 6	Answers	BAKERY dataset	CARS dataset	[November 27, 2007]
Lab 6	Answers	CSU dataset	MARATHON dataset	[November 27, 2007]
Lab 6	Answers	STUDENTS dataset		[November 27, 2007]

JDBCTest.java
classes12.jar (JDBC driver)

PL/SQL examples

example1.sql	Inserts a row into table	[November 13, 2007]
example2.sql	Simple use of cursor	[November 13, 2007]
example4.sql	Cursor + loop	[November 13, 2007]
example5.sql	for-loop for cursors	[November 13, 2007]
example3.sql	paremeterized cursor	[November 13, 2007]

Course Datasets

Homework 1

Due: October 16

Postscript

PDF

[October 8, 2007]

Homework Solutions

• SQL-92 Syntax description.

Oracle

General Database Resources

• DBLP - Database and Logic Programming Bibliography server. (ACM mirror. Original site is here).[posted: Sep 25]

• ACM SIGMOD (Special Ineterst Group on Management Of Data).

  • ACM SIGMOD Repository of publically available database software.