CIS 385 Home Page
CIS 385 is an introduction to Database theory.
Tests:
The third exam will be on Tuesday, November 25. It will the presentations described below as well as chapters 3, 5, 10, 11, 16, 17, 18.
The final exam will be on Monday, December 15 at 1:00.
The assignments
Create a database assignment. This is a zip file containing a document and a data file. We will discuss on Thursday.
There is a follow-up assignment on paper to the load a real database asssignment below. It is due on Tuesday October 28.
Load a working database.
Presentations
The intent is to have the presentations available before the start of class. They will be left here for some time after class.
Not yet covered.
The third Schema refinement presentation.
The second Schema refinement presentation. Updated 11/20.
The disk manager presentation.
Covered.
The Virtual Memory presentation.
The first Schema refinement presentation. Updated 11/20.
The third test will include those presentations below here.
The recovery presentation.
The transaction management presentation.
The general concurrency presentation.
The Hash index and hash join presentation.
The introductory hashing presentation.
The B Tree presentation.
SQL DML presentation.
SQL DDL presentation.
Textbook
Database Management Systems (3rd ed.) Ramakrishnan and Gehrke
Important documents overviewing the course:
The syllabus for CIS 385 (Word format)
Files and handouts
A description of the sample schemas for the college database (Word format). We will use this both for examples and exercises. New on 10/15.
Other links of interest
The home page for the textbook.
The What you need to know About: Databases. web page.
The SQL test page.
Return links
Return to Curt Hill's home page.
Last time I updated this page: November 20, 2008.