Consider the Pine Valley Furniture Company database designed and implemented during the previous semester. Recall the major relations in the database, including:
There is a requirement to implement a web-based solution for the above-mentioned database. The web-based solution must incorporate the following functionalities:
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.
Try to incorporate business intelligence concepts into your project. You may consider the following options:
Design interfaces of your project.
Develop a page to demonstrate various events which are raised and handled during ASP.NET page processing once the page object has been created.
Learn how line by line code execution can be realized. Write its benefits below?
The next task is to convert plain HTML into web forms in order to realize a web application.The application should incorporate following functionalities:
When the page visitor enters a search string in an input control, and text box and click a search button, all relevant products must be displayed to the page visitor.
You are required to implement web form for New Customer Registration for Pine Valley Furniture Company.Who will be the user of this web form?
You are required to implement web form for updating customer data by customers.
You are required to implement web form for Product Catalog Update.
You are required to implement web form for Products Selection and Order Placement.
Refer to Lab 1 (Problem 1), Lab 4 (Problems 3 and 4) and Lab 5 (Problems 1 to 4).You are required to design and implement Role Base Access control mechanism for Pine Valley Furniture Company interfaces developed so far in above mentioned problems.
This lab focuses on implementing a Customer Segmentation System for Pine Valley Furniture Company. The system categorizes customers based on their purchase behavior such as total spending and purchase frequency. Customers are divided into segments like Premium, Regular, Occasional and Inactive to help improve business decision-making.
This lab focuses on implementing a Recommendation System for Pine Valley Furniture Company. Recommendation System A recommendation system for an order processing system analyzes historical order data, user behavior, and item characteristics to predict and suggest products that a customer is likely to purchase next. These systems (i) Improve customer experience (ii) Increase Average Order Value (AOV) by identifying purchasing patterns and offering personalized recommendations. Recommendation Techniques ->Collaborative Filtering (CF): Recommends items based on similar user behavior. If user A and B have similar order histories, the system suggests items purchased by B to user A. ->Content-Based Filtering: Suggests items similar to those a user has already purchased or viewed, based on item attributes (e.g., category, brand, or price). ->Hybrid Systems: Combines collaborative and content-based filtering to overcome limitations like the "cold start" problem (new users/items with no history). Association Rule Mining Identifies items frequently bought together, ideal for "frequently bought together" bundles or upselling complementary items.