IAD LABS
Lab 01
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 above mentioned database. The web based solution must incorporate following functionalities:
- New Customer Registration
- Searching of Products
- Product Selection and Order Placement
- Product Catalog Update
- Payment Provision
As a first step design 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 following options:
- i) Try to transform order processing system into a customer segmentation analysis platform.
- ii) How user profiling can be added into basic order processing system?
- iii) How targeted marketing can be realized?
- iv) Add recommendation system feature in your project.
Lab 02
Q1)
Upload and host pages developed in Lab 01
Lab 03
Q1)
Create GUI Prototypes for our own project
Lab 04
Q1)
Develop a page to demonstrate various events which are raised and handled during ASP.NET Page processing once the page object has been created. (Develop in Visual studio and the host it on your site)
Draw (in space given below) the page processing sequence and write description about it? (For solution you may refer to class discussions, presentations and live demonstrations.)
Q2)
With reference to above Problem 1, you are required to do experiment with debugging using break points. Learn how line by line code execution can be realized. Write its benefits below?
Q3)
Refer to Lab 1 in which paper prototyping and HTML interfaces were developed for Pine Valley Furniture Company. The next task is to convert plain html into web forms in order to realize a web application. The application should incorporate following functionalities:
- New Customer Registration
- Searching of Products
- Product Selection and Order Placement
- Product Catalog Update
- Payment Provision
Q4)
Implement the search mechanism (functionality) for searching products (furniture products) through the above mentioned Page (ii) as listed in Problem 3. When the page visitor enters a search string in an input control e.g. text box and click a search button, all relevant products must be displayed to the page visitor.
Q5)
Develop and execute test cases for Problem 4. Write details of test cases below?
Lab 05
Q1)
Refer to Lab 4, Problem 3. 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?
Q2)
Refer to Lab 4, Problem 3. You are required to implement web form for updating customer data by customers.
Q3)
Refer to Lab 4, Problem 3. You are required to implement web form for Product Catalog Update.
Q4)
Refer to Lab 4, Problem 3. You are required to implement web form for Products Selection and Order Placement.
Lab 06
Q1)
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.
- (a) As an initial step enhance the schema of PVFC database.
- (b) Next enhance the solutions for above mentioned problems to take advantage of modified schema and incorporate role based access control for all interfaces. Write the updated code for any one of the above problems below?
- (c) Develop test cases for role based access control