You are to design and write Java Program that create and maintain a database for a small business or organization. The application will allow maintaining a database containing records for the application. The actual database may be created externally (i.e. set up the database and associated table(s) from the code ). Once created, the program should allow:
a) add new records
b) change existing records
c) delete records
The learning objectives of this project include:
Consolidate and extend programming skills acquired during the 3rd semester Java course at Sheridan (including concepts from Java I and Java II courses)
Follow a structured program development cycle, including a design stage, a prototyping stage, a coding stage, a testing stage, and a documentation stage
Explore and implement data processing methods and algorithms typically used by businesses
Explore additional features of the programming language
How to go to next level
Read the information on this project thoroughly
Submit a proposal to your instructor prior to beginning work on your project. Although the actual programming task will be very similar for any system chosen, the actual data, reports and queries will be different. The proposal will give you an opportunity to think about the system you have chosen in detail. It will also give you the opportunity to identify the data to be stored, and the reporting / query requirements.
Please note that you do not have to select one of the following projects. The list is meant to give you project ideas.
Store Inventory: keep track of the inventory on hand for a cosmetic store, hardware store, music store, video store, etc.
Trivia Game / Quiz Questions: Keep a database of Trivia / Quiz Questions. Reports could include an actual 10 question quiz.
Customer List: Maintain a mailing list.
Telephone Inventory: Keep track of a corporation's telephones, including the extensions number, features of the phone, name of the employee, and any other useful information.
Home Inventory: Keep track of furniture, appliances and other items in a typical home.
Dental Patient System: Keep track of the patients of a Doctor or Dentist.
Airline Reservations: Keep track of seat availability, passenger lists and other related tasks.
Library Patrons: Keep track of a library's users.
Point of Sales System
Currency conversion System
Car Rental System
Vacation Sales System
Project can be done using Servlet/JSP.
Quality of report
Synthesis of materials
Style of coding
Convention of coding
Project required components
Use of proper GUI design
Use of standard JSP tags
Use of Bean class
Use of Database
Database connection using bean object
Use of appropriate queries
Use of appropriate report/display
Proper exception handling
Special features (one or more)
Complexity of the project (very easy, easy, average, above average, hard, very hard)
Any additional feature which is not listed here
Project Specifications: in a few pages, describe the nature of project and its components /specifications.