CSC 366: Database Modeling, Design and Implementation
Winter 2010

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

Office Hours:

When		Who	Where
Monday	11:00am - 11:50pm	Alex	14-215
Wednsday	11:00am - 11:50pm	Alex	14-215
Wednsday	11:00am - 11:50pm	Alex	14-215
Friday	11:00am - 1:00pm	Alex	14-215

Additional appoinments: send email.

News and Notes

• Project data is now (finally!) available.
  [January 26, 2010]

• Lab 3 description is available.
  [January 11, 2010]

• Everyone should have a working account on the course wiki. Also, project documentation is now available on-line from this page and from the wiki.
  [January 7, 2010]

Course Materials

Project

Project Information

Wiki Documentation Page

Wiki Data Page

Labs

Lab 1	Due: January 4	: SQL test	Postscript	PDF	Lab Data	[January 5, 2010]
Lab 2	Due: January 13	Project Requirements	Postscript	PDF	Documentation	[January 5, 2010]
Lab 3	Due: January 20	Data Model	Postscript	PDF		[January 11, 2010]
Lab 4	Due: January 27	Database Design	Postscript	PDF		[January 19, 2010]
Lab 5	Due: February 8	Software Design/Bulk-loader	Postscript	PDF	Lab/Project Data	[January 26, 2010]
Lab 6	Due: March 3	Access Control	Postscript	PDF		[March 2, 2010]
Lab 7	Due: March 12	XML	Postscript	PDF		[March 5, 2010]

JDBCTest.java
classes12.jar (JDBC driver)

Homeworks

Homework 1	Due: February 1		Postscript	PDF		[January 19, 2010]
Homework 2	Due: February 8		Postscript	PDF		[January 24, 2010]
Homework 3	Due: February 18		Postscript	PDF		[February 12, 2010]

Lecture Notes

Lecture 1	Database Design: Overview	Postscript	PDF	[December 11, 2007]
Lecture 2	Entity-Relationship Model	Postscript	PDF	[January 15, 2008]
Lecture 3	Entity-Relationship Model	Postscript	PDF	[January 17, 2008]
Lecture 4	E-R Model --> Relational Model	Postscript	PDF	[January 24, 2008]
Lecture 5	E-R Model --> Relational Model (examples)	Postscript	PDF	[January 24, 2008]
Lecture 6	Functional Dependencies	Postscript	PDF	[January 29, 2008]
Lecture 7	Functional Dependencies (examples)	Postscript	PDF	[January 29, 2008]
Lecture 8	Normal Forms	Postscript	PDF	[January 31, 2008]
Lecture 9	Normal Forms: Examples	Postscript	PDF	[February 6, 2008]
Lecture 10	Normal Forms: Decomposition	Postscript	PDF	[February 12, 2008]
Lecture 11	Normal Forms: Decomposition Examples	Postscript	PDF	[February 12, 2008]
Lecture 12	Database Security: Data Access Control	Postscript	PDF	[February 28, 2008]
Lecture 13	ODL and Object-Relational SQL	Postscript	PDF	[March 4, 2008]
Lecture 14	XML In a Nutshell	Postscript	PDF	[March 11, 2008]
Lecture 15	DTDs	Postscript	PDF	[March 11, 2008]
Lecture 16	XPath	Postscript	PDF	[March 11, 2008]

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.