Customer Invoice Manager

Instructions

Design, implement and document a customer invoice manager (CIM) application. The application should utilise a GUI front-end and a database back-end to manage customer invoices for a single enterprise. Customer invoice information is to be persisted to a database (Oracle, MySQL, MS Access) between executions of the application.

Features:

The application should provide the following features:

• allow the user to input invoice information on customer purchases;
• retrieve customer invoice information when requested;
• retrieve customer invoice information when requested;
• permit the user to remove customer invoice information; and
• generate various reports based on customer invoice information.

The marks will be allocated based on the level achieved in the assignment. To receive a 40% pass mark, you must develop an application that can carry out at least the following functions:

• add customer invoice information;
• add customer invoice information;
• add customer invoice information;
• list customer invoice information; and
• find an individual customer invoice.

To receive a 50%+ marks, you must develop an application that can:

• satisfy the 40% pass mark requirements;
• demonstrate the use of ‘INNER JOIN’ to multiple tables in your reports; and
• demonstrate the use of ‘MetaData’ in your classes.

To receive a 60%+ mark, you must develop an Application that can:

• satisfy the 50% pass mark requirements; and
• utilise programmer defined Exception classes for Error Handling (i.e. use your own Exception Handling Classes) in your application.