Instructor: Alexander Dekhtyar, dekhtyar@csc.calpoly.edu, 14-212
Office Hours:
| Who | Where | |
Monday | 11:10am - 12:00pm | Alex | 14-212 |
Tuesday | 10:10pm - 11:00am | Alex | 14-212 |
Wednesday | 10:10am - 12:00pm | Alex | 14-212 |
Additional appoinments: send email.
Syllabus | Postscript | |
Lab365 Server | http://labthreesixsix.com | |
Lab 0 Survey | Google Form |
Project Documentation Version 1.0. | |
Project Knowledge Base | Googledoc |
Lab 1 | Due: April 18 | Conceptual Model: Stage 1 | Postscript | [April 10, 2025] | |
Lab 2 | Due: April 25/April 29 | Conceptual Model: Stage 2 | Postscript | [April 22, 2025] | |
Lab 3 | Due: May 13/May 15 | Final Conceptual Model/Logical Model | Postscript | [May 6, 2025] |
Homework 1 | Due: May 6 (or so) | Postscript | [April 21, 2025] | ||
Homework 2 | Due: May 6 (or so) | Postscript | [April 22, 2025] | ||
Homework 3 | Due: May 14 | Postscript | [May 21, 2025] |
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] |