CS145 Outline
or-objects.html
DateTopicReading
9/28The E/R ModelCh. 2
9/30E/R Design, Intro. to Relational Model3.1--3.3
10/5Functional Dependencies3.4, 3.5
10/7Normalization, Multivalued Dependencies3.6, 3.7
10/12Relational Algebra5
10/14SQL Queries6.1--6.3
10/19SQL Queries and Data-definition6.4--6.7
10/21SQL: Views, ConstraintsCh. 7 up to 7.4.1
10/26SQL: Triggers, PSM7.4, 8.2, or-triggers.html
10/28PL/SQL, Embedded SQL8.1, 8.3--8.5, or-plsql.html
11/2CLI, JDBC, Object-Relational Systems 4.5, 8.3--8.5, 9.4, 9.5, or-jdbc.html
11/4Midterm Examinationup to PL/SQL
11/9More OR Systems, Semistructured Data4.6
11/11XML, XPath4.7, Notes
11/16 XQuery Notes
11/18Transactions, Authorization8.6, 8.7
11/23Data warehouses, Data miningNotes
11/30Datalog10.1--10.3
12/2Object-Oriented Databases: ODL, OQL4.1--4.4, 9.1--9.3
12/6Final Exam 3:30 - 6:30 All except 11/30 and 12/2