CSC 366: Database Modeling, Design and Implementation
Winter 2018

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

Office Hours:

When		Who	Where
Monday	10:10am - 11:00am	Alex	14-210
Monday	4:00pm - 5:00pm	Alex	14-210
Wednesday	10:10am - 11:00am	Alex	14-210
Wednesday	4:00pm - 5:00pm	Alex	14-210

Additional appoinments: send email.

News and Notes

• I will be using a googledocs Examples file to build a number of examples to show and discuss in class (it will save me time on drawing tables on the board). New examples will be added to the bottom of the file.

• Our project customer is Dr. Dmytro Marushkevich, Senior Director of Analytics at Sapient RazorFish.

Course Materials

Project

Labs

Lab 1	Due: January 19	SQL test	Postscript	PDF	[January 23, 2018]
Lab 2	Due: January 26	Project Requirements	Postscript	PDF	[January 23, 2018]
Lab 3	Due: February 2	Data Model/Database Design	Postscript	PDF	[February 2, 2018]

Homeworks

Homework 1	Due: February 12		Postscript	PDF	[February 2, 2018]
Homework 2	Due: February 12		Postscript	PDF		[February 5, 2018]

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.