ecommerce using JSP and Servlets - very basic

task is to write a three-tier application (browser, web application, database) that: 1. Allows the user to view a list of products 2. Allows the user to enter product orders 3. Allows the user to view an orders 4. Allows an administrator to list orders 5. Allows an administrator to update orders For this task: 1. Design the application, including web site map, database design, architecture and web pages and forms. 2. Create database tables and queries. 3. Use JSP and Servlets to implement the application and presentation logic. See the JSP lecture slides for possible/preferred architectures. It is highly recommended that you implement this assignment with the Type 2 (Model-View-Controller) architecture. 4. Use JDBC to access the database.