CS 105 - Survey of Computer Science
Spring 2007 – Database Project
20 points
Out: April 20, 2007
Due: May 4 2007 at the beginning of the final exam (12:30pm), no late work accepted

This project is to create a simple database "application" using MS Access. Like all database applications, it will used to keep track of related information in an application area. The application area will be chosen by you within the following guidelines. Here are some ideas for those who cannot think of an application area,

• Music performers, their albums, and their concerts

• Manufacturers of computing equipment, their products, and customers

• Publishers, magazines, and subscribers

• Students, faculty, and courses

Note that if you are responsible for looking up or making up the pertinent information for each table.

Whatever application area you choose, the database must have the following components:

• The database must contain at least three tables (relations) - avoid redundancies similar to those in Figure 9.4 of the textbook

• Each table must have at least 4 fields (attributes)

• Each table must have at least 5 rows (tuples)

• There must be at least 2 queries available that involve data from more than one table and using at least one selection criteria. The results of the query should be something "interesting". E,g., for a database of publishers, magazines, and subscribers might have a query that computes a list of subscribers in a particular state that subscribe to a particular magazine title.

Of course, this is just a minimum. Forms and reports may also be included, but are not required.

To submit this project for grading, email the .mdb file of your project as an attachment to the instructor (hwang@evansville.edu). It is due by 4:30pm, otherwise it will be considered late.