CS 655 - Info. Delivery on the Internet  - Program 2 - Name:_____________

   Assigned: Friday, October 24, 2003
   Due: Monday, November 17, 2003

   (120 points)

   o Put your name and login ID and add necessary comments into the code you 
     created. These are a part of grading in the assignment.

   o Write a document describing the programs you created.

   o Please refer to the popcorn example in 10.4.2.

   o Both the hardcopy and the electronic copy of your code should be 
     submitted. Your login ID should be present in your code.

   o Use the handin system to submit all code including your document 
     electronically. The submission ID is 2.


   This assignment is an ongoing project of the online store you created
   in the first assignment.


   1. Add two following HTML documents to the online store you created in 
      the first assignment. These two HTML documents can be generated by 
      Perl CGI scripts written by you.

    (1) an HTML document that allows customers to search your store and pick 
        the item they wants.

    (2) an HTML domcuent that displays the shopping cart of the customer.

    (3) an HTML domcuent that collects the customer's name, address, and 
        payment method and information. (optional for undergraduates and 
        count 5 bonus points for undergraduates.)


   2. Write SQL scripts to create the database tables for your store and
      insert data into those tables. Because all students use the same 
      database (cs655), you can prefix or suffix those tables with your 
      initials to make those tables unique.


   3. Revise two the Perl CGI scripts created in the Assignment 1:

    (1) a CGI script that validates the data entered and show an appropriate 
        error message when the data entries are not vaild or complete. 
        The valid data is stored into the database. (optional for all 
        students. 5 bonus points)

    (2) a CGI script that produces a list of products that the customer are 
        looking for from the database. Your store should have at least 50 
        items.


   4. Add the following Perl CGI scripts:

    (1) a CGI script that processes the shopping cart of the customer and 
        shows the odered items and total cost.

    (2) a CGI script that stores the customer's order including customer's 
        name, address, and payment method and information into the database 
        and replies a thanks message and order number. (optional for 
        undergraduates and count 5 bonus points for undergraduates.)

   5. Show images of your products. (Optional for all students, 3 bonus
      points)