CS145 Outline

Date	Topic	Reading
9/27	Intro, E/R model	1, 2.2, 2.3, 2.4.3-4
10/2	More E/R	2.5 except 2.5.2, 2.6
10/4	Relational model	3.1, 3.3-5
10/9	Functional dependencies, Normalization	3.6-7
10/11	Multivalued dependencies, Relational Algebra	3.8, 4.1
10/16	SQL queries	5.1-4
10/18	Duplicates, Aggregation, Modifications,	4.6, 5.4-6
10/23	Schemas, Views	5.7-8
10/25	Nulls, Outerjoin, Constraints	5.9, 6.1-3
10/30	More constraints, Triggers	6.4-6, or-plsql.html
11/1	PL/SQL; Embedded SQL	7.1
11/6	Midterm Examination	up to 11/1 lecture
11/8	Object-relational database systems	8.5-6, or-objects.html
11/13	More O-R, Transactions, Authorization	7.2, 7.4
11/15	Datalog	4.2-3
11/20	Recursion in SQL3 and Datalog	4.4, 5.10
11/22	OO design using ODL	2.1, 2.4.1, 2.5.2, 3.2
11/27	OO queries using OQL	8.1-3
11/29	More OQL	8.4
12/4	Semistructured data, XML	Notes
12/6	Data Warehouses, Data mining	Notes