Fall Semester 2002

This is your Practical Exam. Relax, and do well. The exam is open book.
The nominees for the Performance, Variety or Music Program Emmy Awards 2001 are listed below. They have been rated by three judges, the omnipresent Larry, Michael, and Toni. The ratings are on a scale from 1 to 10, with 1 being the lowest, and 10 being the highest rating. A judge must rate at least one nominee, but can rate as many as the judge wants to rate. Here are the (final) ratings.

Judge One (Larry ) Judge Two (Michael) Judge Three (Toni)
Steve Martin 8 3 6
Barbra Streisand 7 - 8
Ellen DeGeneres - - -
David Letterman 9 - 2
Will Ferrell - 5 4
Wayne Brady 6 7 -

A dash (-) in the table above means no rating (NULL).

Please accomplish the following tasks:

Part One (40 points)

Part Two (30 points)

Create the following queries:

Part Three (10 points)

Create a form entitled Performers by Judges which contains

Part Four (10 points)

Create a report in which you list the performers. For each performer

Challenge (10 points)

Please make sure your database fits on a floppy disk.


An A114/I111 Practical Exam - October 4, 2002