MIS 320

1
MIS 320

• Database Design Quiz

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.

3
1. Accounts Table
Less than 30 seconds
4
2. Internship Table
Less than 30 seconds
5
3. Tours Table
Less than 30 seconds
6
4. Task Table
Less than 30 seconds
7
Times Up!

• Please pass your papers to the front
• ?