CS145 Outline
9/27Intro, E/R model1, 2.2, 2.3, 2.4.3-4
10/2More E/R2.5 except 2.5.2, 2.6
10/4Relational model3.1, 3.3-5
10/9Functional dependencies, Normalization3.6-7
10/11Multivalued dependencies, Relational Algebra3.8, 4.1
10/16SQL queries5.1-4
10/18Duplicates, Aggregation, Modifications, 4.6, 5.4-6
10/23Schemas, Views5.7-8
10/25Nulls, Outerjoin, Constraints5.9, 6.1-3
10/30More constraints, Triggers6.4-6, or-plsql.html
11/1PL/SQL; Embedded SQL7.1
11/6Midterm Examinationup to 11/1 lecture
11/8Object-relational database systems8.5-6, or-objects.html
11/13More O-R, Transactions, Authorization7.2, 7.4
11/15Datalog 4.2-3
11/20Recursion in SQL3 and Datalog4.4, 5.10
11/22OO design using ODL2.1, 2.4.1, 2.5.2, 3.2
11/27OO queries using OQL8.1-3
11/29More OQL8.4
12/4Semistructured data, XMLNotes
12/6Data Warehouses, Data miningNotes