Any and all help with this assignment would be greatly appreciated. If possible, please explain the reason why you used each section of code. Thank you in advance!

COMP 5000/6000/6006 JSP Assignment 2 Library catalog Create a web application using JSP, MySOL, and the regular front-end technology stack (HTML, CSS, JavaScript) to allow patrons to interact with your local library's catalog online. Your application can include client-side JavaScript to make the interface more user-friendly, but it should always perform the necessary server-side validations to protect the integrity of the library's catalog and inventory Requirements The librarian has given you the following requirements: . The web application should include a log in and sign up page. Log in page should use a username and password. o o Sign up page should require the following fields: first name, last name, username, password, and password confirmation. o There should be a JSP session running to keep track of whether the user is logged in or not. Any user can browse the catalog, regardless of whether they've signed up or logged in. In other words, there should be no session check on the page that allows browsing of the catalog. o The user should be able to select from a list of topics that filters the books visible on the browsing screen. Filtering by a different topic than the one currently selected should fire off a query to the server -filtering should not be happening in the browser / JavaScript. If no topic is selected, the page should show all books. o o The following information should be shown at a minimum: Book title, book author whether it's available for checkout, and a way to reserve a copy. When they are logged in, users should be able to reserve a copy of their favorite available books from the browse catalog page. If not logged in, the user should still see the button to . reserve the copy which will take them to the log in page upon click. There should be a page which allows logged in users to show their list of reserved books. If not logged in, trying to navigate to this page (even via a direct URL) should require the user to . log in first. Database structure There is one SQL file attached with the assignment to create the database 'library catalog with the following structure