Submission requirements:

• One submission per team.
• Turn in the paper copies of your assignment files. Hard copies should be bound firmly together as one pack. 5 points will be deducted for unbounded homework.
• Zip all the files. Name the zip file as lastname_firstname_projectphase1.zip. Submit the zip file through Blackboard.
• No hard copies or soft copies results in 0 points.

Phase II (100 points)

Assigned Date: Monday November 3, 2014

Due Date: 5:00 PM, Monday November 10, 2014

Requirements:

(90%) Implement the data tier of the website.
•  Design all the database tables and table data to be used in the database for your website.
• Write the E-R diagrams of your database design
•  Write SQL statements and stored procedures for the database table and table data
• Populate the database tables with real data
• Use a statement-of-work table to map the web site functions with tables and stored procedures

(10%) Prepare a 5-minute presentation to disucss the E-R diagrams and the statement-of-work table in class.

Submission requirements:

• One submission per team.
• Turn in the paper copies of all the assignment files including the statement-of-work table, E-R diagrams, SQL statements, and stored procedures. Hard copies should be bound firmly together as one pack. 5 points will be deducted for unbounded homework.
• Zip all the files. Name the zip file using the team lead name as lastname_firstname_projectphase2.zip. Submit the zip file through Blackboard.
• No hard copies or soft copies results in 0 points.

---

Phase III (100 points)

Assigned Date: Monday November 10, 2014

Due Date: 5:00 PM, Wednesday November 19, 2014

---

Requirements:

(90%) Implement a proof-of-concept three-tier of website.
• Implement a function of your ecommernce web site that includes the data tire, the business tier, and the presentation tier.
(10%) Prepare a 5-minute presentation to demonstrate the function in class.

Submission requirements:

• One submission per team.
• Turn in the paper copies of all the assignment files. Hard copies should be bound firmly together as one pack. 5 points will be deducted for unbounded homework.
• Zip all the files. Name the zip file using the team lead name as lastname_firstname_projectphase3.zip. Submit the zip file through Blackboard.
• No hard copies or soft copies results in 0 points.

 

Term Project Final Phase
(200 points)

Due Date: 5:30 PM, Monday Dec 15, 2014

---

Educational Goal:

Implement a real world three-tier ecommerce website.

Requirements:

Prepare PowerPoint slides for a 20-minute presentation. In the presentation you should 1) demonstrate the functions that you have implemented, and the major challenges you have experienced in this term project; and 2) find a real job posting related with web application development and explain which function(s) you have implemented in the term project and help you to get the job offer. Be prepared to explain how the functions are implemented at code level (you may be asked to show the correspondent source codes during the presentation!).

Each team member must participate and present during the 20-minute presentation.

Provide the instructor and the TA the paper copies (2 copies in total) of your PPT slides before your presentation.

During the 20-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. 

Submission requirements:

• Provide the URL of your website. Or bring your laptop to class and contact the instructor if you host the project using 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.
• Zip all the project files. Name the zip file using the team lead name as lastname_firstname_projectfinal.zip. Submit the zip file through Blackboard.
• No hard copies or soft copies results in 0 points.