MIS 320

1
MIS 320

• Quiz 2 (Database Design)

2
Instructions

• Write your student number (not your name) on a
  piece of paper.
  
• This quiz contains four situations.
• Each is a set of sample data that has been
  arranged in a database table.
  
• Each of these contains an error.
• Your job is to identify the error (2 pts.) and
  suggest a solution (½ pt.).
  
• You may use any notes you have made and the class
  lecture notes.
  
• Each situation will be visible for 3 minutes in
  this demo version, press enter to advance.

3
1. Activity Table
4
2. Department Table
5
3. Employee Table
6
4. Bartenders Table