Prepare a pilot example of your case study solution using JSPs, beans, and servlets. Attached you will find an example main menu page for a pilot project. The grade for this project will be a combined grade with the 404 class which will have the same assignment. Prepare a group PowerPoint presentation to brief your pilot. Zip into a single file all JSP, bean, and servlet source code files used in creating your pilot project and attach them to the weekly assignment. All pilot projects deliverables, with the exception of the PowerPoint presentation, must be from individual work, not from group work. Do not forget to fully document all of your source code.

Making a Pilot Project - A 'Pilot' is somewhat like a 'proof of concept' of a project. It is a limited implementation of a project design that provides a testing ground or proves that the original design is sound. For a pilot project in our case studies, we will need to show that our general idea of how the case study solution should work is sound. In the short series of web pages you create for your pilot project, you will solve one of the common problems with a typical E-Commerce site. The following 'Students-Classes' example will provide guidance on solving this problem. The concept behind the case studies in our courses is to create database tables and an interface that shows how the case study could be solved. There are many solutions to most of the case study problems. However, most solutions will have at least one 'many to many' relationship. In a 'many to many' relationship it is usually necessary to create a third table so that the relationships can be broken down to 'one to many'. In most cases, the 'many to many' relationship will be between customer orders and products. For each product, there may be many orders and for each order, there could be many products. However, resolving the 'many to many' problem is generic and we will solve it generically.

Pilot Project Requirements - Using the above as a background, implement a user interface (very basic) for your pilot project. Your Pilot Project will need to implement a minimum of the following interfaces into the database:

A menu page that links to all the pages in your project.

A page to create all required tables and insert the initial records needed for the application to function.

A page to drop all tables used in the project.

A form, that when submitted, inserts data into a database table(s).

A page the displays the data in the table(s) updated for verification.

The pages for this project should not be plain white pages. Add a few images, styles sheets, etc. that enhance the pages' appearance.

This assignment is on a winery, so I need the JSP, Beanfile, and Servlet to include the different types of wines, log in page, pictures of wines, and everything listed above.