Internet Application Development

Question 1

Consider the project database designed and implemented during the previous semester (Fall 2024). Its implementation was done using structured query language. Recall the major relations in your project database. You already have its printed report.

There is a need to implement a web-based solution for the above-mentioned database. The solution must incorporate the following functionalities:

1. Registration of Student/Patient/Passenger/Customer (as applicable)
2. Search facilities, including partial matches
3. Any other project-specific functionalities
4. Role-based access control
5. Payment system (if required)

As a first step, design the above-mentioned user interfaces using paper and pencil. Next, write appropriate HTML for creating these user interface prototypes.

Further Requirements:

• Create navigation links among the pages
• Design a menu using lists and styles
• Add help pages for user guidance
• Use either table-based or flow-based layout
• Test prototypes in a browser
• Experiment with style sheets

Question 2

To extend the scope of the project, incorporate Business Intelligence (BI) features in your system. Consider the following:

1. Apply segmentation analysis in your system
2. Implement user profiling functionality