Part Five: Application Programming

Total Points: 100
Total Weight: 5%
Due: Friday, December 4, 2009, in class

Description

In this part, you will implement your application program.
Specifically, your tasks are the following.

1. PL/SQL Package

   You should create a PL/SQL package including at least one procedure and one function. These functions and procedures will implement some of the application functionality and can be used in the embedded SQL.

2. Application Programming

   Implement your application program in Java/JDBC, Pro*C/C++, or some other language. Specific requirements of the program are listed below.

   1. It should implement the functionality of your application as you proposed in your ( revised) Part One of the project. Specifically, functions for data update, various predefined or dynamic queries, and business rule enforcement.

   2. It should provide either a menu driven or a graphical (or web) user interface. It should be user-friendly.

   3. The program should handle exceptions and errors gracefully.

   4. If you program in Pro*C/C++, at lease one subprogram should use a cursor (in addition to any cursor used in your PL/SQL package). If you program in Java/JDBC, this should be done as result sets.

What to Hand In

Hand in a well-formatted written final report include following items. (I will keep the final report on my file so you should make copies for yourselves as appropriate)

1. Revised Report of Previous Parts

   Since this is the final report, it should be complete. Therefore, it should include a fresh copy of revised reports of ALL previous Parts, ordered chronically.

2. Function Lists

   A list of originally proposed functions and a list of actually implemented functions.

3. Program Source

   A script of your PL/SQL package. and a copy of your program source code.

4. Script and Screen Shots

   Include a script that shows the compilation and execution of your program. You should show, within a user session, all functions currently supported by your application. If your program provides a graphical user interface, include some screen shots as well.

5. Summary of the Entire Project

   You should include a summary section in which you should summarize the team's activities during the project; your experiences gained from this project; positive and negative aspects of your design and implementation methodology and team work. You should comment on whether and how this project contributes towards your learning of database subjects and discuss possible future extensions of your project. Optionally, you may comment on how each team members contributes to the overall project. Please be specific and insightful.