Problem Statement

Consider the Pine Valley Furniture Company database designed and implemented using structured query language during previous semester. Try to recall major relations in the database (CUSTOMER_T, ORDER_T, ORDER_LINE_T, and PRODUCT_T).

There is a need to implement a web-based solution for the above-mentioned database. The web-based solution must incorporate the following functionalities:

1. New Customer Registration
2. Searching of Products
3. Products Selection and Order Placement
4. Product Catalog Update
5. Payment Provision

As a first step, design the above-mentioned (i) to (v) user interfaces using paper and pencil.

Next, write appropriate HTML for creating (i) to (v) user interface prototypes.

Create links for navigation among the above pages. Design a menu using lists and styles. Add help pages for user guidance. Either use a table for layout or may opt for flow-based layout. Test user interface prototypes in a browser. Experiment with style sheets.

Moving towards Business Intelligence

1. Try to transform order processing system into a customer segmentation analysis platform.
2. How user profiling can be added into the basic order processing system?
3. How targeted marketing can be realized?