CSC 366: Database Modeling, Design and Implementation
Spring 2022

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

Office Hours:

When		Who	Where
Monday	9:10am - 10:00am	Alex	14-212
Tuesday	9:10pm - 10:00am	Alex	14-212
Wednesday	9:10am - 11:00am	Alex	14-212

Additional appoinments: send email.

News and Notes

• Lab365 Server login
  [March 29, 2022]

• Website is up!
  [March 29, 2022]

• Our customer is Dr. Anya Goodman, Professor, Department of Chemistry and Biochemistry, Cal Poly, and Dr. Dan Bachrach, Professor, Culverhouse College of Business, University of Alabama.

Course Materials

Project

Labs

Lab 1	Due: April 8	SQL test			[March 29, 2022]
Lab 2	Due: April 17	Project Requirements	Postscript	PDF	[April 4, 2022]
Lab 3	Due:April 28	Data Model/Database Design	Postscript	PDF	[April 19, 2022]
Lab 4	Due: May 12	Software Design	Postscript	PDF	[May 5, 2022]
Lab 5	Due: May 19	Data Loader	Postscript	PDF	[May 10, 2022]
Lab 6	Due: May 26	Matching Algorithms	Postscript	PDF	[May 16, 2022]

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.