Instructor: Alexander Dekhtyar, dekhtyar@csc.calpoly.edu, 14-212
Office Hours:
| 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.
[March 31, 2024]
Syllabus | Postscript | |
Lab365 Server | http://labthreesixsix.com | |
Lab 0 Survey | Google Form | |
CalMatters Digital Democracy Portal | digitaldemocracy.calmatters.org |
Documentation: CalAccess LEAKS: Part 1 | |||||
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 |
Lab 0 | Due: April 4 / April 9 | Getting Ready | Postscript | [April 2, 2024] | |
Lab 1 | Due: April 8 | SQL test | [April 4, 2024] | ||
Lab 2 | Due: April 19 | Project Requirements | Postscript | [April 10, 2024] | |
Lab 3 | Due: May 3 | Data Model/Database Design | Postscript | [April 25, 2024] | |
Lab 4 | Due: June 8 | CalAccess LEAKS DB construction | [May 7, 2024] |
Homework 2 | Due: May 14/May16 | Postscript | [April 30, 2022] |
Lecture 1 | Database Design: Overview | Postscript | [December 11, 2007] | |
Lecture 2 | Entity-Relationship Model | Postscript | [January 15, 2008] | |
Lecture 3 | Entity-Relationship Model | Postscript | [January 17, 2008] | |
Lecture 4 | E-R Model --> Relational Model | Postscript | [January 24, 2008] | |
Lecture 5 | E-R Model --> Relational Model (examples) | Postscript | [January 24, 2008] | |
Lecture 6 | Data Warehouses | Postscript | [April 30, 2024] | |
Lecture 7 | Functional Dependencies | Postscript | [January 29, 2008] | |
Lecture 8 | Functional Dependencies (examples) | Postscript | [January 29, 2008] | |
Lecture 9 | Normal Forms | Postscript | [January 31, 2008] | |
Lecture 10 | Normal Forms: Examples | Postscript | [February 6, 2008] | |
Lecture 11 | Normal Forms: Decomposition | Postscript | [February 12, 2008] | |
Lecture 12 | Normal Forms: Decomposition Examples | Postscript | [February 12, 2008] | |
Lecture 13 | Database Security: Data Access Control | Postscript | [February 28, 2008] | |
Lecture 14 | ODL and Object-Relational SQL | Postscript | [March 4, 2008] | |
Lecture 15 | XML In a Nutshell | Postscript | [March 11, 2008] | |
Lecture 16 | DTDs | Postscript | [March 11, 2008] | |
Lecture 17 | XPath | Postscript | [March 11, 2008] |
SQL-92
Oracle
General Database Resources