IAD Problem Statement
Consider the database development project developed during previous semester. A complete database design and development was carried out in previous semester project as detailed in your project report in printed form.
In addition during one of previous labs (see reference below) you were required to develop web interfaces on paper and then develop html prototypes for various functionalities of your database project mentioned as above.
Now the next task is to transform paper based and html based prototype interfaces into full scale working web forms for realization of various functionalities of your project. Ideally you are required to develop all web forms for implementing various project functionalities.
Reference: Lab 3 Q1)
Consider the Pine Valley Furniture Company database designed and implemented using structured query language
during 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:
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 (i) to (v) user interfaces using paper and pencil.
Then write appropriate HTML for creating the interface prototypes.
Create links for navigation among pages, design a styled menu, add help pages,
and test interfaces in the browser. Experiment with style sheets.