BUS/CPT 357
Franklin College
Summer 2003
Erich Prisner,

Visual FoxPro-

Project 2

Use Visual FoxPro to create a simple exe File for the library. The library rules are

• Each book is due 4 weeks after checking it out,
• If the book is not back after 4 weeks, the customer gets a reminder, but can no longer check books out.
• If the book is not back after 6 weeks, the customer gets another reminder

You need tables for customers, for books, for authors, and for transactions.

Tables for books and authors you can find here, here, here, and here. The customer tables are here and here again. Import these files into your VFP database. For the customer table you should use (and extend) the names table you created in the previous birthday sample project. 

The transaction tables you should create form scratch. Possible fields are

• transaction number (?)
• customerID
• bookID
• checkout (date)
• checkin (date)

There should be a book form, usable for the customers, where they are supposed to search for books by last name of the author or by complete (English) title.

There should also be forms for checkout and checkin.

Finally, a report should list all names and addresses of customers whose books are due this week (for reminding them nicely).

• All tables with indexes and relationships: 20%
• The "late" view: 10%
• The checkout form: 10%
• the checkin form: 10%
• the allbooks form: 20%
• the late report: 20%
• Everything working: 10%

Here is a help page for the project