CSC 366: Database Modeling, Design and Implementation
Spring 2011

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

Office Hours:
When
Who Where
Tuesay 3:00pm - 4:00pm Alex 14-215
Wednsday 9:00am - 12:00pm Alex 14-215
Thursday 3:00pm - 4:00pm Alex 14-215

Additional appoinments: send email.

News and Notes

Old News and Notes

Course Materials

Syllabus Postscript PDF
Groups HTML
Wiki HTML
Project Presentations

Project

Project Due: June 6 Implementation instructions and deliverables Postscript PDF [May 10, 2011]

Labs

Lab 1 Due: April 5 SQL test Postscript PDF Lab Data [March 30, 2011]
Lab 2 Due: April 12 Project Requirements Postscript PDF Documentation [April 4, 2011]
Lab 3 Due: April 21 Data Model/Database Design Postscript PDF [April 14, 2011]
Lab 4 Due: April 28 Software Design Postscript PDF [April 21, 2011]
Lab 5 Due: May 5 Data Loader Postscript PDF Lab/Project Data [April 27, 2011]
Lab 6 Due: May 31 Object-oriented data model Postscript PDF [May 24, 2011]
Lab 7 Due: June 2 Access Control Postscript PDF [June 1, 2010]

JDBCTest.java
classes12.jar (JDBC driver)

Homeworks

Homework 1 Due: May 3 Postscript PDF [April 21, 2011]
Homework 2 Due: May 10 Postscript PDF [May 2, 2011]
Homework 3 Due: May 10 Postscript PDF [May 2, 2011]

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

Oracle

General Database Resources

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