Recommended exercises to prepare for Exam 2

Recommended exercises to prepare for Exam 2 (Chapters 6-9 of Ullman & Widom.)

1. Several sql query questions. Some of these using MySQL workbench/MySQL.

6.1.2, 6.1.3, 6.2.1,6.2.3,6.3.1, 6.4.6, 6.5.1

2. Short answer questions covering central topics in database management. Transactions, constraints, triggers, indexes, views.

7.1.1, 7.1.3, 7.2.1, 7.2.2;

8.1.1, 8.1.2, 8.3.1

3. Short answer questions covering n-tier systems.

9.6.1 and 9.7.1 (based on 9.3.1)

4. Again, several multiple choice questions copied from the Stanford videos.