Recall the project database designed and implemented during the Fall 2024 semester using Structured Query Language (SQL). Refer to the printed project report to identify the major relations (tables) in your database.
Your task is to develop a web-based solution for this database, incorporating the following functionalities:
(1) Registration for users such as students, patients, passengers, customers, or other relevant entities based on your project.
(2) Search functionality with support for partial matches.
(3) Additional project-specific features relevant to your database.
(4) Role-based access control to manage user permissions.
(5) A payment system, if applicable to your project.
To begin, follow these steps:
- Design user interfaces for functionalities (1) to (5) using paper and pencil sketches.
- Create HTML prototypes for these user interfaces.
- Implement navigation links to connect all pages.
- Develop a menu using HTML lists and CSS styles.
- Include help pages to guide users.
- Choose either a table-based or flow-based (CSS) layout for the design.
- Test the HTML prototypes in a web browser.
- Experiment with CSS style sheets to enhance the design.