CS 366: Database Modeling, Design and Implementation
Winter 2008

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

Office Hours:

When		Who	Where
Monday		Alex	14-209
Tuesday	3:00pm - 4:00pm	Alex	14-215 and/or 14-302
Wednsday	9:00am - 12:00pm	Alex	14-215
Thursday	3:00pm - 4:00pm	Alex	14-215 and/or 14-302

Additional appoinments: send email.

News and Notes

• Customer checklist for project demos is now available.
  [March 18, 2007]
• Instructor checklist for project demos is now available. Customer checklist is pending approval.
  [March 18, 2007]
• Project implementation instructions are now available.
  [March 3, 2008]
  
• NUTRITION dataset is now available. The README file is here. Individual files can be downloaded via links below.
  [February 27, 2008]

• Use cases from the customer are now available.
  February 25, 2008]
• A few use cases from the customer are now available.
  [February 19, 2008]
• Lab 4 and the final version of customer's software specification are now available.
  [February 4, 2008]
• First version of the customer's software specification is now available. This document is still incomplete in a few places, but all information that may be helpful for Lab 3 assignment is in it.
  [January 30, 2008]

• Lab 3 dealine has been extended to January 31 (Thursday).
  [January 27, 2008]

• The class now has a project wiki. It will be used to "stockpile" all useful information about the project. Wiki accounts will be created for all students in the class shortly.
  [January 22, 2008]

• Solutions for Lab 1 are now posted.
  [January 22, 2008]

• Customer documentation for Lab 2 is posted below (under "Lab Data").
  [January 15, 2008]

• All photographs from January 10 lab are now posted. Please remember, they were taken with a 1.1 Mbp camera.
  [January 15, 2008]

Course Materials

Labs

Lab 1, Part 1	Due: January 8	: SQL test	Postscript	PDF	[January 8, 2008]
Lab 1, Part 2	Due: January 10	Groups	Postscript	PDF	[January 11, 2008]
Lab 2	Due: January 22	Requirements elicitation, database design	Postscript	PDF	[January 14, 2008]
Lab 3	Due: January 29 31	Database redesign, wiki, logical design	Postscript	PDF	[January 24, 2008]
Lab 4	Due: February 21	Software design, database creation, queries	Postscript	PDF	[February 4, 2008]
Lab 5	Due: March 4	Data Access	Postscript	PDF	[March 4, 2008]
Lab 6	Due: March 10	Object-Relational Database Model	Postscript	PDF	[March 4, 2008]
Lab 6	Due: March 13 (by class time)	Semistructured Data Model, XML	Postscript	PDF	[March 11, 2008]

Lab Data

Lab 2	Customer Narrative(by Stephanie Yarbro and Mark Edwards)	MS Word		[January 15, 2008]
Lab 2	Additional Customer Narrative(by Mark Edwards)	MS Word		[January 15, 2008]
Lab 4	Software Specification (draft)(by Mark Edwards)	MS Word
Lab 4	Final Software Specification(by Mark Edwards)	MS Word		[February 4, 2008]
Lab 4	Some Data(by Mark Edwards)		Excel	[January 31, 2008]
Lab 4	Use Case 1: Add Taxonomy Item	MS Word		[February 18, 2008]
Lab 4	Use Case 2: Add Specimen	MS Word		[February 18, 2008]
Lab 4	Use Case 3: Add Location	MS Word		[February 18, 2008]
Lab 4	Use Case 4: Assign diet to animal	MS Word		[February 25, 2008]
Lab 4	Use Case 5: Add/Edit Ingredient	MS Word		[February 25, 2008]
Lab 4	Use Case 6: Add stock to inventory	MS Word		[February 25, 2008]
Lab 4	Use Case 7: Remove stock from inventory	MS Word		[February 25, 2008]
Lab 4	Use Case 8: Edit Specimen	MS Word		[February 25, 2008]
Lab 4	Use Case 9: Archive Specimen	MS Word		[February 25, 2008]
Lab 4	Use Case 10: Create new diet	MS Word		[February 25, 2008]
Lab 6	Combined presentation		Powerpoint	[March 11, 2008]

NUTRITION dataset v 1.1 README taxon.csv animals.csv [deprecated] animals-g.csv genders.csv locations.csv location_assgnment.csv ingredient_categories.csv ingredients.csv diets.csv diet_assignments.csv inventory.csv withdrawls.csv users.csv NUTRITION.zip [February 27, 2008]

NUTRITION dataset v. 1.0
README
taxon.csv animals.csv locations.csv location_assgnment.csv ingredient_categories.csv ingredients.csv diets.csv diet_assignments.csv inventory.csv withdrawls.csv users.csv
NUTRITION.zip
[February 27, 2008]

Lab Tests

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

JDBCTest.java
classes12.jar (JDBC driver)

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