CS145 Outline
DateTopicReadingLecturer
9/25The E/R modelCh. 2Ullman
9/30E/R design exercise and examples - Rajaraman
10/2Relational model, Functional Dependencies3.1--3.5Ullman
10/7Normalization, Multivalued dependencies3.6, 3.7Ullman
10/9Relational Algebra5 Rajaraman
10/14SQL queries6.1--6.3Rajaraman
10/16SQL queries and data-definition6.4--6.7Rajaraman
10/21Constraints and TriggersCh. 7, or-triggers.htmlRajaraman
10/23PSM and PL/SQL8.2, or-plsql.htmlUllman
10/28Embedded SQL, CLI, JDBC8.1, 8.3--8.5, or-jdbc.html, Rajaraman
10/30Object-relational systems4.5, 9.4, 9.5, or-objects.html Ullman
11/4Midterm Examinationup to 10/30 lecture -
11/6Datalog10.1--10.3Rajaraman
11/11SQL recursion10.4, NotesRajaraman
11/13Transactions, Authorization8.6, 8.7Rajaraman
11/18Universal Modeling Language, Object-Description LanguageNotes, 4.1--4.4Ullman
11/20Object-Oriented Databases: OQL9.1--9.3Ullman
11/25Semistructured data, XML4.6, 4.7, NotesUllman
12/2XPath, XQuery Notes Chamberlin
12/4XQuery Notes Chamberlin