Lab 1: Problem Statement

Dated: Friday, 06th February 2026

Q1)

Consider the Pine Valley Furniture Company database designed and implemented during the previous semester. 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 solution must incorporate the following functionalities:

• i. New Customer Registration
• ii. Searching of Products
• iii. Products Selection and Order Placement
• iv. Product Catalog Update
• v. Payment Provision

As a first step:

• Design the above-mentioned user interfaces (i) to (v) using paper and pencil.
• Write appropriate HTML for creating (i) to (v) user interface prototypes.
• Create links for navigation among the above pages.
• Design a menu using list and styles.
• Add help pages for user guidance.
• Either use table-based layout or flow-based layout.
• Test user interface prototypes in a browser.
• Experiment with style sheets.

Q2)

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

• i. Transform the order processing system into a customer segmentation analysis platform.
• ii. How user profiling can be added into the basic order processing system.
• iii. How targeted marketing can be realized.
• iv. Add recommendation system feature in your project.