AUCTIONBASE

• Database Schema
• Initial Data

Phase I

1. Consolidated Data
   You may copy the above file to your tinman folder using the following command:

   cp ~raj/public_html/4710/sp08/project/d.sql .
   

   I have also set up servlet access for most students - except for 8!; Please set up your webapps folder structure soon so that I can activate servlet access for remaining 8!
   Each student needs to submit 10 items using the format shown in the Initial Data script. The category assignments are as follows:

   Books:Biology Andrew Velez 1000
   Books:Computers Umar Arshad 1010
   Books:Economics Nick Larsen 1020
   Books:Fiction Philip Rogers 1030
   Computers:Apple:Desktops None
   Computers:Apple:Laptops Cheng Li 1040
   Computers:PCs:Desktops Vivek Shah 1050
   Computers:PCs:Laptops Ming Fang 1060
   Computers:Storage:Hard Drives Yiyun Wu 1070
   Computers:Storage:Flash Drives Rasmi Nayak 1080
   DVDs:Action Pavan Kanduri 1090
   DVDs:Comedy Anusha K. 1100
   Music:Blues Sandeep V. 1110
   Music:Jazz Nazia Islam 1120
   Music:World Violeta Deneva 1130
   Video Games:Systems:XBox 360 Senait Kidane 1140
   Video Games:Systems:Wii Troy Longo 1150
   Video Games:Systems:Playstation Brandon Baldwin 1160
   Video Games:Systems:Nintendo DS Andres Avendano 1170
   Video Games:Games:XBox 360 Kim Yin 1180
   Video Games:Games:Wii Liu Zhaofan 1190
   Video Games:Games:Playstation Blanca 1200
   Video Games:Games:Nintendo DS Minh To 1210
   

2. Implement the "Browse/Search" part of the AuctionBase website.

   Each Web page in this part should have a "Top" portion which contains:

   • A "Bread Crumb" indicating the level of the category being browsed. For example, the initial page should have HOME as the bread crumb. Lower levels of categories would have bread crumbs such as HOME::DVDS::FICTION, HOME::DVDS, HOME::BOOKS, HOME::BOOKS::ECONOMICS, etc. Each of these terms in the bread crumbs should be hyper-linked so that when they are clicked, the page refreshes and shows the level that is clicked.
   • A "Search" text box and a pull-down list of top-level categories and a submit button. This should allow users to search for items using keyword. The results of the search should be shown in list form.

   The Web page should contain a "Bottom" portion which lists either the sub-categories for the rightmost category in the bread crumb or a list of items if the rightmost category in the bread crumb is the lowest level category. These sub-categories and items should be hyper-linked as well. The sub-categories should be hyper-linked to the next level page and the items should be hyper-linked to a "Detail" page for the item.

   The "Detail Page" for the item should list all details of the item and should provide a text box for the user to enter a bid and a submit button.

Phase II

1. Login/logout.
2. Update member profile.
3. Place a bid.
4. View closed items along with open items. This should be be displayed along with browse/search options, but with no text box/submit button for "bid".
5. Place feedback.
6. View feedback/ratings for a particular member.