CS 365: Database Systems
Spring 2008

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

Office Hours:

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

Additional appoinments: send email.

Final Exam Date: Tuesday, June 10, 2008, 1:10pm

News and Notes

Course Materials

Labs

Lab 1, Part 1	Due: April 8	Why databases?	Postscript	PDF
Lab 1, Part 2	Due: April 15	Why databases?	Postscript	PDF
Lab 2	Due: April 17	SQL DDL, DML	Postscript	PDF
Lab 3	Due: April 29	SQL DDL, DML	Postscript	PDF
Lab 4	Due: May 6	Simple SQL Queries	Postscript	PDF
Lab 5	Due: May 15	Counting with SQL	Postscript	PDF
Lab 6	Due: May 22	Complex SQL Queries	Postscript	PDF
Lab 7	Due: June 3	JDBC	Postscript	PDF
Lab 7	Due: June 6	PL/SQL	Postscript	PDF

Lab Data

Lab 1: Part 1	students.txt		[April 1, 2008]
Lab 1: Part 2	teachers.txt	teachers.txt	[April 8, 2008]

Lab Tests

Lab 1:	Public Test Suit	Script for Java implementations	Results	[April 10, 2008]
Lab 1:	Public Test Suit	Script for Java implementations	Full Results	[April 14, 2008]
Lab 1-2:	Public Test Suit (with results)			[April 10, 2008]
Lab 1-2:	Final Test Suit (with results)			[April 14, 2008]
Lab 2:	AIRLINES dataset test	BAKERY dataset test	CARS dataset test	[April 15, 2008]
Lab 2:	CSU dataset test	MARATHON dataset test	STUDENTS dataset test	[April 15, 2008]
Lab 2:	STUDENTS dataset formatted result	BAKERY dataset formatted result		[April 15, 2008]
Lab 2:	Lab 2 full grading script			[April 23, 2008]
Lab 3:	AIRLINES dataset test	BAKERY dataset test	CARS dataset test	[April 23, 2008]
Lab 3:	CSU dataset test	MARATHON dataset test	STUDENTS dataset test	[April 23, 2008]
Lab 3:	Lab 3 full grading script	Enrollments table after DELETE		[April 23, 2008]
Lab 4:	AIRLINES query counts	BAKERY query counts	CARS query counts	[May 1, 2008]
Lab 4:	CSU query counts	MARATHON query counts	STUDENTS query counts	[May 1, 2008]
Lab 4:	AIRLINES dataset test	BAKERY dataset test	CARS dataset test	[May 7, 2008]
Lab 4:	CSU dataset test	MARATHON dataset test	STUDENTS dataset test	[May 7, 2008]
Lab 5:	AIRLINES dataset test	BAKERY dataset test	CARS dataset test	[May 13, 2008]
Lab 5:	CSU dataset test	MARATHON dataset test	STUDENTS dataset test	[May 13, 2008]
Lab 8:	BAKERY test 1 (functions)	BAKERY test 2 (procedures)		[June 5, 2008]
Lab 8:	AIRLINE test 1 (direct_connect)	AIRLINE test 2 (one_stop_connect)	AIRLINE test 3 (num_flights)	[June 5, 2008]

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]
example10.sql	Stored procedure: insert a row into table	[May 29, 2008]
example11.sql	anonymous block that uses example10 procedure	[May 29, 2008]
example12.sql	stored function: max price for given food type	[May 29, 2008]
pack.sql	Package	[June 3, 2008]
example15.sql	using the package	[June 3, 2008]

Course Datasets

• 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.