CSC 366: Database Modeling, Design and Implementation
Spring 2019

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

Office Hours:

When		Who	Where
Monday	9:10am - 11:00am	Alex	14-210
Tuesday	1:10pm - 2:00pm	Alex	14-210
Friday	10:10am - 11:00am	Alex	14-210

Additional appoinments: send email.

News and Notes

• Revised documentation is now up!.
  [April 10, 2019]
  
• Website is up!
  [April 6, 2019]

• Our customer is Dr. Heather Liwanag, Assistant Professor, Department of Biology, head of the Vertebrate Integrative Phisiology Lab at Cal Poly.

Course Materials

Project

Labs

Lab 1	Due: April 8	SQL test	Postscript	PDF	[April 2, 2019]
Lab 2	Due: April 17	Project Requirements	Postscript	PDF	[January 10, 2019]
Lab 3	Due:April 24	Data Model/Database Design	Postscript	PDF	[April 26, 2019]
Lab 4	Due: May 13	Use Case Formalization	Postscript	PDF	[April 28, 2019]

Homeworks

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.