CS 365: Database Systems
Spring 2010

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

Office Hours: Tuesday
When
Who Where
11:00am - 12:00pm Alex 14-209
Wednsday 9:00am - 12:00pm Alex 14-209
Thursday 1:00pm - 2:00pm Alex 14-209

Additional appoinments: send email.

News and Notes

Old News and Notes

Course Materials

Syllabus Postscript PDF

Final Evaluation

Essay Assignment Due: June 11 Postscript PDF [May 27, 2010]

Labs

Lab 1, Part 1 Due: April 1 Why databases? Postscript PDF Lab Data [March 29, 2010]
Lab 1, Part 2 Due: April 8 Why databases? Postscript PDF Lab Data [April 4, 2010]
Lab 2 Due: April 15 SQL DDL, DML Postscript PDF Lab Tests [April 6, 20101]
Lab 2: Handin Instructions Due: April 15 SQL DDL, DML Postscript PDF [April 8, 2010]
Lab 3 Due: April 22 SQL DDL, DML Postscript PDF [April 15, 2010]
Lab 4 Due: May 4 Simple SQL Queries Postscript PDF Lab Data [April 22, 2010]
Lab 5 Due: May 13 Counting with SQL Postscript PDF [May 6, 2010]
Lab 6 Due: May 20 Complex SQL Queries Postscript PDF [May 18, 2010]
Lab 7 Due: May 27 JDBC Postscript PDF [May 18, 2010]
Lab 8 Due: June 5 PL/SQL Postscript PDF [May 27, 2010]

JDBCTest.java
ojdbc14.jar (JDBC driver)

Course Datasets

CSU Dataset
README
Campuses.csv
csu-fees.csv
degrees.csv
discipline-enrollments.csv
disciplines.csv
enrollments.csv
faculty.csv
CSU.zip
[September 26, 2007]
CARS Dataset
README
car-makers.csv
car-names.csv
cars-data.csv
continents.csv
countries.csv
model-list.csv
cars.desc
CARS.zip
[September 26, 2007]
BAKERY Dataset
README
customers.csv
goods.csv
items.csv
reciepts.csv
BAKERY.zip
[October 1, 2007]
STUDENTS Dataset
README
list.csv
teachers.csv
STUDENTS.zip
[October 1, 2007]
MARATHON Dataset
README
marathon.csv
MARATHON.zip
[October 8, 2007]
AIRLINES Dataset
README
airlines.csv
airports100.csv
flights.csv
AIRLINES.zip
[November 19, 2007]

Homeworks

Homework 1 Due: April 29, 2010 Postscript PDF [April 15, 2010]

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]

Lecture Notes

Lecture 1 Why Databases ? Postscript PDF [September 14, 2007]
Lecture 2 Databases in a Nutshell Postscript PDF [September 16, 2007]
Lecture 3 Relational Database Model Postscript PDF [September 20, 2007]
Lecture 4 SQL DDL and DML Postscript PDF [September 16, 2007]
Lecture 5 Oracle's SQL*Plus client Postscript PDF [September 16, 2007]
Lecture 6 Relational Algebra Postscript PDF [October 3, 2007]
Lecture 7 SQL DATE type and built-in functions Postscript PDF [October 8, 2007]
Lecture 8 SQL SELECT Postscript PDF [October 8, 2007]
Lecture 9 SQL: Aggregation Operators Postscript PDF [October 23, 2007]
Lecture 10 SQL: GROUP BY and HAVING clauses Postscript PDF [October 25, 2007]
Lecture 10: Example GROUP BY and HAVING clauses Postscript PDF [October 29, 2007]
Lecture 11 SQL: Nested Queries Postscript PDF [October 29, 2007]
Lecture 12 JDBC Postscript PDF [November 5, 2007]
Lecture 13 PL/SQL: Part 1 Postscript PDF [November 8, 2007]
Lecture 14 PL/SQL: Part 2 Postscript PDF [November 13, 2007]
Lecture 15 PL/SQL: Part 3 Postscript PDF [November 20, 2007]

Other Materials

SQL-92

Oracle

General Database Resources

August 28, 2007, dekhtyar at csc.calpoly.edu