CS 100M

Assignment 16

December 3, 2008

Purpose: Experience a database, Filemaker Pro5

Due: December 8, 2008

Make a credit card database, as described in class.

Starting with a new database, enter fields for at least:

A. Credit card (text - list))

B. Date (date type)

C. Location (text)

D. Description (text)

E. Amount (number - Currency)

Using at least 4 different types of credit card (I'd suggest Visa, Mastercard, Discover, American Express), enter at least 20 Credit Card records, with at least 2 for each card. Prepare a report that lists all the purchases by credit card, and calculates a dollar subtotal for each card, and a grand total for all the transactions.

Hand in a printed copy of this report, nicely formatted.

(Due December 8, 2008; I won't accept any homework after the final exam.)