Instructor: Alexander Dekhtyar, dekhtyar@csc.calpoly.edu, 14-212
Office Hours:
| 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.
Syllabus | Postscript | |
Lab365 Server | http://labthreesixsix.com |
Documentation: Version 1.0 | ||
Documentation: Version 2.0 | ||
Draft URE Survey | ||
URE experience - O*Net data Spreadsheet | Excel | Version 2.0 |
The O*Net Website | HTML | |
Moreson/Humphrey paper | ||
Knowledge Repository | GoogleDoc | |
Use Cases | GoogleDoc | (Under Construction) |
Data | Main Dataset (Excel) - Version 01 | Profile Characteristics (csv) | Data Version 3 | Main Dataset (Google Drive) - Version 03 |
Lab 1 | Due: April 8 | SQL test | [March 29, 2022] | ||
Lab 2 | Due: April 17 | Project Requirements | Postscript | [April 4, 2022] | Lab 3 | Due:April 28 | Data Model/Database Design | Postscript | [April 19, 2022] | Lab 4 | Due: May 12 | Software Design | Postscript | [May 5, 2022] |
Lab 5 | Due: May 19 | Data Loader | Postscript | [May 10, 2022] | |
Lab 6 | Due: May 26 | Matching Algorithms | Postscript | [May 16, 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 | Functional Dependencies | Postscript | [January 29, 2008] | |
Lecture 7 | Functional Dependencies (examples) | Postscript | [January 29, 2008] | |
Lecture 8 | Normal Forms | Postscript | [January 31, 2008] | |
Lecture 9 | Normal Forms: Examples | Postscript | [February 6, 2008] | |
Lecture 10 | Normal Forms: Decomposition | Postscript | [February 12, 2008] | |
Lecture 11 | Normal Forms: Decomposition Examples | Postscript | [February 12, 2008] | |
Lecture 12 | Database Security: Data Access Control | Postscript | [February 28, 2008] | |
Lecture 13 | ODL and Object-Relational SQL | Postscript | [March 4, 2008] | |
Lecture 14 | XML In a Nutshell | Postscript | [March 11, 2008] | |
Lecture 15 | DTDs | Postscript | [March 11, 2008] | |
Lecture 16 | XPath | Postscript | [March 11, 2008] |
SQL-92
Oracle
General Database Resources