Principles of Database Systems
Fall 2009
Overhead Slides
Notes:
The best way to view these files under Unix/Linux is to use the command
gv
under Unix/Linux on the ps.gz files.
To print several pages on one physical sheet, use the command
psnup
on the ps files under Unix/Linux.
Lecture Slides:
Introductory slides:
PS.gz
PDF
Slides on entity-relationship modelling:
PS.gz
PDF
Slides on basic concepts of the relational model:
PS.gz
PDF
Slides on conversion of an ER description to a relational schema:
PS.gz
PDF
Slides on queries and query languages:
PS.gz
PDF
Slides on SQL:
PS.gz
PDF
Slides on updates:
PS.gz
PDF
Slides on views:
PS.gz
PDF
Slides on database access via programming languages:
PS.gz
PDF
Slides on the use of ODBC within the programming language C:
PS.gz
PDF
Slides on functional dependencies:
PS.gz
PDF
Slides on physical database design:
PS.gz
PDF
Slides on physical database organization and query processing:
PS.gz
PDF
Slides on the database system catalog:
PS.gz
PDF
Slides on transaction processing and concurrency control:
PS.gz
PDF
Slides on recovery techniques:
PS.gz
PDF
Slides on security and authorization:
PS.gz
PDF
Slides on limitations of the relational model:
PS.gz
PDF
Slides on object-oriented concepts:
PS.gz
PDF
Slides on object-relational concepts:
PS.gz
PDF
Other Slides:
Independence and Interoperability in Database Systems:
PS.gz
PDF