| Slides From Autumn,
1999
|
The following slides are available in postscript and PDF.
They are from Jeff Ullman's offering of the CS145 course in the Autumn
of 1999.
Each set of slides represents a 1.25 hour lecture, of which there are 20
in this course.
You are welcome to download these slides and use them as you wish.
- Lecture 1, Intro, E/R Model
Postscript
PDF
- Lecture 2, More E/R model
Postscript
PDF
- Lecture 3, Network, hierarchical, and relational models
Postscript
PDF
- Lecture 4, Subclasses, FD's, BCNF
Postscript
PDF
- Lecture 5, Decomposition of relations, Relational algebra
Postscript
PDF
- Lecture 7, Intro to SQL
Postscript
PDF
- Lecture 7, More SQL: Aggregation, Duplicates, DB Modification
Postscript
PDF
- Lecture 8, Yet More SQL: Schema Definition, Views
Postscript
PDF
- Lecture 9, Yet More SQL: NULL's, Outerjoins, Constraints
Postscript
PDF
- Lecture 10, Constraints: Triggers, Assertions
Postscript
PDF
- Lecture 11, PL/SQL, Embedded SQL
Postscript
PDF
- Lecture 12, Intro. to object-relational SQL
Postscript
PDF
- Lecture 13, Finish O-R SQL; Lossless-join decomposition
Postscript
PDF
- Lecture 14, Third Normal Form, Fourth Normal Form
Postscript
PDF
- Lecture 15, Datalog
Postscript
PDF
- Lecture 16, Stratified recursion, Recursion in SQL3
Postscript
PDF
- Lecture 17, ODL
Postscript
PDF
- Lecture 18, Introduction to OQL
Postscript
PDF
- Lecture 19, More OQL
Postscript
PDF
- Lecture 20, Information integration, Semistructured data, and XML
Postscript
PDF