CS145 - Introduction to Databases
Spring 2000, Prof. Widom

Midterm Exam: Logistics and Review

Information

Review Session

A question-and-answer review session will be conducted by one of the TA's on Tuesday May 2 from 7:00-8:30 PM in the usual CS145 classroom: the Gates Computer Science Building Room B01 (the Hewlett-Packard Auditorium). Please bring questions or specific problems for the TA. The review session will not be televised.

Material Covered

The exam will cover:

Since the material on transactions, authorization, and programming with SQL (covered in class and in the readings) has not yet been exercised in an assignment, any questions regarding this material on the exam will be straightforward.

What follows is an outline of the material we've covered so far. All of this material is fair game for the midterm exam.

  1. Basic motivation and database terminology

  2. Entity-relationship model and E/R diagrams

  3. Relational model

  4. Relational database design

  5. Relational algebra

  6. SQL

  7. Indexes

  8. Transactions, Authorization, Programming with SQL: cursory coverage only