Lab 1 Problem Statement

Q1)

Consider the Pine Valley Furniture Company database designed and implemented during the 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:

• New Customer Registration
• Searching of Products
• Products Selection and Order Placement
• Product Catalog Update
• 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 above pages.

Design a menu using list and styles.

Add help pages for user guidance.

Either use table for layout or may opt for flow-based layout.

Test user interface prototypes in browser.

Experiment with style sheets.

Q2)

Try to incorporate business intelligence in your project. You may consider the following options:

• Try to transform order processing system into a customer segmentation analysis platform.
• How user profiling can be added into basic order processing system?
• How targeted marketing can be realized?
• Add recommendation system feature in your project.