CSC 366: Database Modeling, Design and Implementation
Winter 2012

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

Office Hours:

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

Additional appoinments: send email.

News and Notes

• Because of the class size, we are moving (at least for the first two-three weeks of the course) into 14-301 for the lab period.
  [January 3, 2012]

Course Materials

Project

Labs

Lab 1	Due: January 4	SQL test	Postscript	PDF	Lab Data	[January 4, 2012]
Lab 2	Due:January 18	Project Requirements	Postscript	PDF	Documentation	[January 10, 2012]
Lab 3	Due:January 30	Data Model/Database Design	Postscript	PDF		[January 18]
Lab 4	Due: February 6	Software Design				[]
Lab 5	Due: February 15	Data Loader	Postscript	PDF	Lab/Project Data	[February 8, 2012]
Lab 6	Due:	Object-oriented data model				[]
Lab 7	Due:	Access Control				[]

JDBCTest.java
classes12.jar (JDBC driver)

Homeworks

Homework 1	Due: January 30		Postscript	PDF		[January 22, 2012]
Homework 2	Due: February 6		Postscript	PDF		[February 5, 2012]
Homework 3	Due: February 13		Postscript	PDF	Solutions (PDF)	[February 6, 2012]

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.