Test 1

date: Wednesday, October 31

time: 2:00-2:50

format: Open text and notes. Bring blank paper.

Sample first midterm from Fall 2003 (sample solution).

TOPICS:

• Data modeling
  • reading: chapters 2 and 3
  • fair questions: Design an E-R diagram, convert an E-R diagram to a relational model

• Relational algebra
  • reading: chapter 4
  • fair questions: Convert a simple relational algebra query to SQL or vice versa.

• SQL
  • reading: chapter 5
  • fair questions: Write some SQL queries or updates.