Feb 20th, 2005
Solution for Sample Exam I: [PDF]
Feb 18th, 2005
Coverage for Exam I:
Q1 Basic Concepts (ch 1-2) - not multiple
choice, but descriptive
Q2 EER - asking you to draw an EER diagram
and point out constraints not captured by the diagram
Q3 Relational Model: keys, referential integrity
and using referential integrity asking you to reverse engineer to ER.
Q4. Relational Algebra and some tuple
calculus. (You may omit Sec 6.7 on domain calculus).
Feb 2nd, 2005
Sample Exam 1 [PDF]