CS 437/637 Database-Backed Web Sites and Web Services

Term Project Phase I
(100 points)

Assigned Date: Wednesday November 23, 2011

Due Date: 11:59 PM, Sunday December 4, 2011

Implement a real world three-tier ecommerce website.

Requirements:

• Design data diagram of your database tables.  
• Create the database of your ecommerce website.
• Create tables inside the database using SQL.
• Insert at least 50 products into the database, including price, description, and location of product images using SQL.
• Save the product images in a local file folder.

Submission requirements:

• Submit the data diagram, the SQL scripts to create database tables and insert production information into the tables.
• Submit a short report of the business objective of your ecommerce website.
• Turn in the paper copies of the source code of SQL scripts. Hard copies should be bound firmly together as one pack. 5 points will be deducted for unbounded homework.
• Submit the softcopy of the slides through your UMassOnline. Zip all the files including the cover page into one ZIP file. Name the ZIP file as Web_projectPhaseI_lastname_firstname.
• You must create the database, tables, and table data at the fantasyland.cs.umb.edu. 
• No hard copies or soft copies results in 0 points.

Term Project Phase II
(200 points)

Assigned Date: Wednesday December 7, 2011

Due Date: 3:00 PM, Wednesday December 21, 2011

Implement a real world three-tier ecommerce website.

Requirements:

• Design and implement the three-tier ecommerce website to display the products information online.
• Must use the factory method to access database (refer to the generic data access class we discussed in the class).
• Must implement paging to display the complete catalog page by page.
• Detailed product information should be displayed if a particular product is clicked by a user.
• Demonstrate your project in a 10-minute presentation in class. During the 10-minute presentation, you must demonstrate all the key functions of your project either using the fantasyland server or your laptop. You should also discuss your experiences learned and lessons gained in this project. 
• Provide the instructor the paper copy of your PPT slides before your presentation.

Submission requirements:

• Submit the absolute path name of your web site at the fantasyland server. Bring your laptop to class and contact the instructor in class if you use your own laptop.
• Turn in the paper copies of the source code of your website. Hard copies should be bound firmly together as one pack. 5 points will be deducted for unbounded homework.
• Submit the softcopy of the slides and your complete project files through your UMassOnline. Zip all the files including the cover page into one ZIP file. Name the ZIP file as Web_projectPhaseII_lastname_firstname.
• No hard copies or soft copies results in 0 points.