Lab 3 – Due Tuesday, February 14, 20006

This assignment is to be submitted as a group assignment: 1 copy per group.

I’d prefer that you type it onto this page but if you have already written a significant amount, you may finish on the page you started in class as long as it is legible. Each group member must sign and the signature is an indication that they actually worked on it outside of class.

Group members: _______________________________________________

Note that there are additional copies of the handout from class outside my office door in the bin closest to the fire extinguisher.

In class we established that there are the following input documents needed.

1. Artist information form
2. Collector (i.e. buyer) information form
3. Art information form
4. Sale Invoice
5. Mailing List form

For each of the above, list the information that needs to be included (i.e. the attributes of the entitities OR show the design of a form to hold the information needed.

Next indicate the routine reports to be produced using the database. Again, you may do it by naming them and showing the attributes (information) to be included in each OR by drawing a form to hold the desired information. These are the output documents needed.

Lastly, Make a list of assumptions for the Art Gallery Project. (for this you want to include items that are explicitly indicated in the handout as well as those that you think make logical sense (are implied).