CSC 366: Database Modeling, Design and Implementation
Spring 2009

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

Office Hours:

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

Additional appoinments: send email.

News and Notes

• Project presentations will take place on Wednsday, June 11, 9:00am-12:00pm. We will announce the location later. The presentation schedule is here.
  [May 26, 2009]

• New use cases document is now available.
  [April 29, 2009]

• The product data (gzipped tar) has arrived. More detailed description will be available shortly, and individual files will be uploaded to the wiki at some point.

  As a short note. The archive contains a catalogs.csv file in its root, which contains the list of catalogs and six directories: one per case study (manufacturer). Each directory contains a pair of csv files describing the products and the product options respectively for each catalog/language pair.
  [April 20, 2009]

• The case studies (pdf) document for the project is now available. The document outlines six manufacturers (four real, two fictional) whose products and catalogs will be made available to you as the data for the project.
  [April 15, 2009]

• SQL*PLUS instructions, in case you need some reference materials for Lab 1.
  [April 1, 2009]

• Lab 1 on Thursday, April 2 is an SQL test. The lab will use the EXTENDED BAKERY dataset. Read the description and the README, browse the data, get familiar.
  [April 1, 2009]

Course Materials

Project

Labs

Lab 1	Due: April 4	: SQL test	Postscript	PDF	[April 5, 2009]
Lab 2	Due: April 17	Database Model	Postscript	PDF	[April 5, 2009]
Lab 3	Due: April 28	Database Design	Postscript	PDF	[April 20, 2009]
Lab 4	Due: May 7 May 12	Application Design	Postscript	PDF	[April 27, 2009]
Lab 5	Due: May 14	Access Control	Postscript	PDF	[May 13, 2009]
Lab 6	Due: May 25	Object-Relational databases	Postscript	PDF	[May 18, 2009]

Project/Lab Data

Lab 1	Dataset	EXTENDED BAKERY (1000 Receipts)	Description(PDF)
Lab 1	Dataset	README(wiki)	README (download)
Project/Lab2	Customer Dcoumentation	Database description (PDF)	Use Cases(PDF) - original	Use Cases (PDF) - updated
Project	Customer Dcoumentation	Case Studies (PDF)
Project	Data	Gzipped Tar
Project, Lab 4	Catalog Files	all-catalogs.csv

Lab Tests

Lab 1	SQL test script	[January 8, 2008]
Lab 1	Lab 1 solutions	[January 22, 2008]

JDBCTest.java
classes12.jar (JDBC driver)

Homeworks

Homework 1	Due: April 23, 2009 (Thursday)		Postscript	PDF	Solutions (PDF)	[April 13, 2009]
Homework 2	Due: April 30, 2009 (Thursday)		Postscript	PDF	Solutions (PDF)	[April 20, 2009]
Homework 3	Due: May 7, 2009 (Thursday) May 12, 2009 (Tuesday)		Postscript	PDF		[April 27, 2009]

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.