Test 1
CIS451/551, Fall 2007
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.