CSC 366: Database Modeling, Design and Implementation
Spring 2024

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

Office Hours:
When
Who Where
Monday 1:10pm - 2:00pm Alex 14-212
Tuesday 10:10pm - 11:00am Alex 14-212
Wednesday 10:10am - 12:00pm Alex 14-212

Additional appoinments: send email.


News and Notes

Course Materials

Syllabus Postscript PDF
Lab365 Server http://labthreesixsix.com
Lab 0 Survey Google Form
CalMatters Digital Democracy Portal digitaldemocracy.calmatters.org

Project

Documentation: CalAccess LEAKS: Part 1 PDF
Documentation: CalAccess LEAKS: Part 2: Relevant forms Googledoc
Project Knowledge Base Googledoc
CalAccess Web Site HTML
CalAccess Materials: Lobbying Lobbying Directory (PDF) Individual Lobbyists Lobbying Firms Lobbyist Employers Payments to Influence
CalAccess Materials: Campaign Finance Campaign Finance Campaign Committees
California Regulations Lobbyist Rules Campaign Rules

Labs

Lab 0 Due: April 4 / April 9 Getting Ready Postscript PDF [April 2, 2024]
Lab 1 Due: April 8 SQL test [April 4, 2024]
Lab 2 Due: April 19 Project Requirements Postscript PDF [April 10, 2024]
Lab 3 Due: May 3 Data Model/Database Design Postscript PDF [April 25, 2024]
Lab 4 Due: June 8 CalAccess LEAKS DB construction PDF [May 7, 2024]

Homeworks

Homework 2 Due: May 14/May16 Postscript PDF [April 30, 2022]

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 Data Warehouses Postscript PDF [April 30, 2024]
Lecture 7 Functional Dependencies Postscript PDF [January 29, 2008]
Lecture 8 Functional Dependencies (examples) Postscript PDF [January 29, 2008]
Lecture 9 Normal Forms Postscript PDF [January 31, 2008]
Lecture 10 Normal Forms: Examples Postscript PDF [February 6, 2008]
Lecture 11 Normal Forms: Decomposition Postscript PDF [February 12, 2008]
Lecture 12 Normal Forms: Decomposition Examples Postscript PDF [February 12, 2008]
Lecture 13 Database Security: Data Access Control Postscript PDF [February 28, 2008]
Lecture 14 ODL and Object-Relational SQL Postscript PDF [March 4, 2008]
Lecture 15 XML In a Nutshell Postscript PDF [March 11, 2008]
Lecture 16 DTDs Postscript PDF [March 11, 2008]
Lecture 17 XPath Postscript PDF [March 11, 2008]


Other Materials

SQL-92

Oracle

General Database Resources


March 29, 2015, dekhtyar at calpoly.edu