Q1) Web-Based Solution for Pine Valley Furniture Company

Consider the Pine Valley Furniture Company database designed and implemented during the previous semester. Recall the major relations in the database, including:

• CUSTOMER_T
• ORDER_T
• ORDER_LINE_T
• PRODUCT_T

There is a requirement 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
• Product Selection and Order Placement
• Product Catalog Update
• Payment Provision

As a first step, design the above-mentioned user interfaces (i) to (v) using paper and pencil. Next, write appropriate HTML to create user interface prototypes for these functionalities.

Create navigation links among all pages. Design a menu using lists and CSS styles. Add help pages to guide users. You may use either table-based layout or flow-based layout. Test the user interface prototypes in a web browser and experiment with style sheets.

Q2) Incorporation of Business Intelligence

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

• Transform the order processing system into a customer segmentation analysis platform
• Add user profiling features into the basic order processing system
• Implement targeted marketing strategies
• Add a recommendation system feature into the project