By the end of the project, you will have developed a functional Online Library Management System

app that meets the requirements

$*....$

The system will provide a user$-$

friendly interface, efficient book management processes, secure user authentication, and a robust

database design. Your work will showcase your understanding of various analysis and design

techniques, in$-$depth understanding of Java coding $($Classess and Inheritance, error handling, form

handling etc.$),$ database programming using MySQL$,$ as well as your ability to apply principles of

user interface design and system controls to create a well$-$rounded and effective software solution.

Question $1$

$[70$ marks$]$

Develop the OLMS app described in the scenario above using Java. Use MySQL to store your

database base tables.

RUBRIC$1)$ Develop an application using Java, MySQL$,$ HTML & CSS$,$ and PHP$.$

$2)$ Test the complete application as per the Rubric Requirements.

Scenario:

You have been tasked with developing an Online Library Management System $($OLMS$).$

This project aims to create a comprehensive system that enables students, faculty, and staff to easily access and manage the library's resources. The system will include features for searching and borrowing books, managing user accounts, and maintaining a secure and user$-$friendly interface.

The proposed app should have the following functionalities:

The application should allow the admin user $($Librarian$)$ to add, update, delete, process book Ioan request $($accept or decline$),$ create and manage user accounts.

If the book is out for loan, the admin user $($Librarian$)$ must decline the request otherwise, accept it$.$

Project Outcome:

By the end of the project, you will have developed a functional Online Library Management System

app that meets the requirements of Boston City Campus library. The system will provide a userfriendly interface, efficient book management processes, secure user authentication, and a robust

database design. Your work will showcase your understanding of various analysis and design

techniques, in$-$depth understanding of Java coding $($Classess and Inheritance, error handling, form handling etc.$),$ database programming using MySQL$,$ as well as your ability to apply principles of

user interface design and system controls to create a well$-$rounded and effective software solution. Follow the rubric.

The app should allow a user to search, borrow books. See the figure below in the first picture: