The exam will be 60 minutes long. It is closed book and closed notes. However, you will have the entire class period available if needed. Questions will be both multiple-choice and full text questions. The topics have been covered in homework assignments 1 and 2.

Solutions: Solutions are available here

• The relational model

  • Schemata and Instances
  • Integrity Constraints

• Relational algebra

  • Write relational algebra expressions
  • Translate SQL into relational algebra

• SQL: Write SQL statements and evaluate them

  • Write DDL commands to create new tables
  • Write SQL queries or evaluate them
  • Write SQL inserts, updates, and delete