Midterm #2

The material on the test was covered in class, and you will also have seen it in

• Lecture notes
• Chapters 5 and 7 of optional text
• Homeworks 3 and 4
• Labs (especially week 6)

Sample Test: from Fall 2005 (sample answers)

This test will cover your understanding of SQL. In addition, there may be one modeling question.

BRING A PENCIL

The questions may be of various forms

• Multiple choice
• True or False
• Short answers
• One or two design problems, for which you give an ER diagram (using ER Studio style)
• We may provide 1 or 2 designs and ask you questions about them.

There may be multiple choice or T/F questions, but mostly you will be writing SQL (or an ER model).

Be sure to thoroughly understand:

• SELECT statements
• inner joins
• how to put a query in the FROM clause
• outer joins
• sub-queries
• aggregate functions, GROUP BY, and HAVING