CSC 365: Database Systems

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

Office Hours:

When		Who	Where
Tuesday	5:00pm - 6:00pm	Alex	14-212
Wednesday	9:10am - 11:00pm	Alex	14-212
Tuesday	5:00pm - 6:00pm	Alex	14-212

Additional appoinments: send email.

News and Notes

• Welcome to CSC 365!

Course Materials

Labs

Lab 1, Part 1	Due: April 9	Why databases?	Postscript	PDF	Lab Data	[September 23, 2024]
Lab 1, Part 2	Due: October 8	Why databases?	Postscript	PDF	Lab Data	[October 1, 2024]
Lab 2	Due: April 22	SQL DDL, DML	Postscript	PDF	Lab Tests	[October 8, 2024]
Lab 3-1	Due: October 17	SQL DDL, DML	Postscript	PDF		[October 17, 2024]
Lab 3-2	Due: October 24	Python + SQL DDL, DML	Postscript	PDF		[October 22, 2023]
Lab 4-1	Due: October 29	SQL SELECT	Postscript	PDF		[October 24, 2024]
Lab 4-2	Due: November 5	SQL SELECT	Postscript	PDF		[October 29, 2024]
Lab 5	Due: November 14	SQL SELECT and Counting	Postscript	PDF		[November 4 , 2024]
Lab 6	Due: November 21	Counting and grouping	Postscript	PDF		[November 17, 2024]
Lab 7	Due: December 10	Complex SQL Queries	Postscript	PDF		[November 21, 2024]

oracle2mysql.py: DATE/TIME conversion functions from Oracle to MySQL
convertdate.py: sample test script for oracle2mysql.py functions.

Course Datasets

datasets-CSV.tar.gz - get all the data in a single file.

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 receipts.csv BAKERY.zip [October 1, 2007]	STUDENTS Dataset README list.csv teachers.csv STUDENTS.zip [October 1, 2007]	KATZENJAMMER Dataset (Version 2.0) README Albums.csv Band.csv Instruments.csv Performance.csv Songs.csv Tracklists.csv Vocals.csv KATZENJAMMER.zip [September 21, 2016]
MARATHON Dataset README marathon.csv MARATHON.zip [October 8, 2007]	AIRLINES Dataset README airlines.csv airports100.csv flights.csv AIRLINES.zip [November 19, 2007]	WINE Dataset README appellations.csv grapes.csv wine.csv WINE.zip [March 27, 2011]	INN Dataset README Rooms.csv Reservations.csv INN.zip [April 6, 2011]

Homeworks

Homework 1	Due: October 29, 2024		Postscript	PDF	[October 17, 2024]
Homework 2 (Midterm Study Guide)	Due: December 5, 2024		Postscript	PDF	[November 21, 2024]

Lecture Notes

Other Materials

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