1. Introduction

The assignment is a continuation of the first assignment. You will use all your knowledge of web and internet to develop a fully functional site. We expect your assignment to be developed as if it is for a real industry client. The assignment would represent what is referred to as the "beta" version in industry, which would be presented to the client for approval and sign-off. 

The web application is expected to use HTML/XHTML, JavaScript, CSS, PHP and Oracle. 

2. Marking Criteria

Final marks of the assignment will depend on the quality and creativity of your web design, web authoring, and web programming. Your submission will be evaluated according to the following criteria:

i. Web by Criterion We will mainly check the Content, the Structure and Navigation, the Visual Design, the Functionality, the Interactivity and the Overall Experience.

 ii. Script 

a.        Client-side scripts to implement validation of form fields in forms where appropriate; 

b.       Server-side scripts to implement the database functionality; 

c.        Well developed and structured script, and appropriate and consistent comments throughout the code. The comments should be detailed so that the marker does not need to read your code to understand what it is doing.

3. Requirements

You should extend assignment by adding the following features. 

CSS

Create an external cascading style sheet that all pages will link to specifying: 

a)      Body with the font Verdana, second choice of Arial, third choice sans serif; 

b)      Body background color of your choice (or background image); 

c)      Hover effect for hyperlinks.  

Any presentational tags/attributes (for example, font tag and bgcolor attribute) should be replaced with appropriate styles.   

PHP and Forms

Design HTML forms for accepting user input. The forms should be database driven i.e. submitting the forms will initiate database interaction. 

i. Query form: it is used to process queries about products. The form have to be linked to the database and retrieve product information based on the criteria selected by the user. For example, show all products which cost less than $100.00.

ii. Feedback form: The form will permit users to provide feedback about their experience in using the website. The form should have appropriate fields as shown below: 

1)      First name

2)      Last name

3)      Email address

4)      Comments

The data from the form will be stored in a database table. The page consisting of the feedback form should have a link to a page that will retrieve and display all comments posted by users. 

JavaScript

Suitable form validation should be implemented for each form.