COSC-3421, Winter 2010
Projects III: APPs

In this project, you will work again with an existing database, the YRB database from project II.

Project III, APPs, is to write an application program for the YRB. Application programs are often called "APPs" in jargon. As your APP will modify the YRB, this is the reason everyone has his/her own copy of YRB for the project.

APPs (Project III)

Write an application program in Java to do the following. Go to JDBC on PRISM at CSE York and check out the instructions on how to write and compile SQL application programs. Provided are some on-line examples.

Search and Purchase application:
  • A customer should be able to search for a book based on a category or title. In particular a customer should be able to specify a category or a string from a title (and all books with that string in the title should be displayed). If a customer does not exist or does not belong to any clubs, an appropriate message should be returned.
  • After the search the customer should be able to buy the book. This will involve:
    • take the customer id, info about the book and day he/she wants to buy the book
    • check if the customer exists
    • if so, add info to denote that the customer buys the book and pick the minimum price that the customer can get for the clubs they are in
    • return success or failure info.
Deliverables

Due by Tuesday 6 April 2010, 10:00pm.

When you are finished, hand in the following.

  1. hard copy

    1. Your source program.

    2. A recorded session of executing your program.

      This should include a variety of scenarios to demonstrate that your program can handle different situations. Explain each of the scenarios in a sentence or two.

Use standard size (8×11) paper and stapled together. Do not use binders, folders, paper clips etc; just pure standard size paper.

  1. electronic copy (same content as hard copy)

    • Use the submit command to turn in your work.

Grading

Marking Scheme (Total is 20 points.)

  1. Requirements working: 12 points
  2. Comprehensive (doesn't mean repetitive) test cases: 3 points
  3. Error checking: 2 points
  4. Programming style: 3 points