Answer Happy

Programming Language to create the website is PHP
SECTION-A 170 Marks] You are required to write a full program code for Library Management System based on the information provided. Maldives Public Library just started its operation. Tunded by government, this library is accessible by the general public and operated by three (3) librarians. Hence, these librarians are in need of Library Management System to help them in the library operation. The system typically needs to allow librarians to store all the books information and assist in borrowing and returning books process. All the requirement for the system is explained in details as below. 1.0 Star-up Page First of all, the system needs to have a start-up page for the librarian. This page consists of: Functions Descriptions Library Logo This is the logo of the library which needs to design it based on your creativity. Welcoming Text This is the text to welcome all the users into the system. Register Button Button for new users to register an account in this system Login Button Button for the existing users to login into the system before using it. 1.1 Registration Page Input Details Name Staft ID Phone Number Descriptions Name of the librarian that want to register a new account in this system The librarian needs to input the staff ID which consists of strings and numbers (ex: ABC123456) The librarian needs to input the phone number into the system. Allow the librarian to insert a chosen username that consist of strings and numbers. This password must be in between 8-12 length and compulsory to have strings and numbers in it. Display a message for validation if the user entered existing data (name, staff id, phone number, username and password) Username Password Message Box Page 2 of 8
1.2 Login Page For the login page, the existing users (the librarians) need to input all the information details: Input Details Descriptions Username Insert the existing username Password Insert the existing password Message Box Display a message for validation if the user entered the wrong username or password 2.0 Menu List Page After users have successfully login into the system, they can access the menu list page of this Library Management System. This page Menu List Descriptions Books Details This is the menu button to redirect user to the books details page that consist all of the book's information provided in the library. Borrowers This is the menu button to redirect user to the borrower's details page that consist information about the borrower. Book Issue This is the menu button to redirect user to the book issue information page, which is a page to enter all the information needed when someone wants to borrow the book. Book Return This is the menu button to redirect user to the book return information page, which consist of information about the book that have been retumed, Late Return This is the menu button to redirect user to the late return information page that consist of information about the late return of the book. User This is the menu button to redirect user information page that consist the information about all the users of the system. Login Information Display the current user that have login into the system, current date and time. 2.1 Books Details Page When users click on the Books menu in the menu list page, it will show this books details page. Page 3 of 8
This page consists of all of the below functions: Functions Search Add Descriptions This function allows users to search a book based on ISBN, author or title (user can choose either one) and the details information of the book will be displayed in the same page (display data: ISBN, Year of Publication, book title, author, Publisher name, category of the book) This allows users to add a new book detail in the database (data need to add: ISBN, Year of Publication, book title, author, Publisher name, category of the book) Allow users to update existing books information and details. This function allows users to delete the existing books in the system. This function shows the list of all books that are in the library To exit this page and return to the menu list page Update Deleto List of Books Return 2.2 Borrowers Information Page When users click on the Borrowers menu in the menu list page, it will show this borrowers information page. This page consists of all of the below functions: Functions Borrowers Details Search Add Descriptions This function consists of all the details about borrowers (display data: borrowers name, IC, phone number, address, no. of books borrows and a list of books that have borrowed) This function allows users to search a borrower name and the details information of the borrower will be displayed in the same page. This allows users to add new borrower information that want to borrow books from this library (data need to add: borrowers name, IC, phone number, address) Allow users to update existing borrowers information and details This function allows users to delete the existing borrowers in the system. This function shows the list of all books that have been borrow which consist of data about book borrowed (ISBN, year of publication, book title, Update Delete List of Books Borrow Page 4 of 8
Borrowers Name Borrowers IC Number List of Books Borrowed (with checkboxes for each of the data in the lists) These text fields are auto generated (user cannot input the data in it) from a search button, where users necd to search the borrowers name in the existing borrower's data and when user selected the existing borrower's data, the borrower's name IC will be displayed in the text fields. This list allows users to tick which books that the horrower want to return (display data: ISBN, year of publication, book title, author, publisher name. issue date, due date. late return status: yes or no, late return fines) If the late return status in the list is yes, display message box that said the person have late return fines that need to be settled and add button that redirect users to the Late Relum Page. User need to click this button to insert the return date data into the database To exit this page and return to the menu list page Book Return button Relum button 2.5 Late Return Information Page When users click on the Late Return menu in the menu list page. it will show this late return information page. In this page, users can see the information about that have not been returned yet and the late return fines information. This page consists of: Functions Descriptions This list displays all of the book information that have not been returned yet (display data: List of Late Return Books borrowers name, IC, phone number, ISBX, year of publication, book title, author, publisher name, issue date, due date, late returns fines) Search This function allows users to search the late return information based on borrower's name or IC number and the details information will be displayed in the same page. This function allows to see the details about the late return fines with the total amount and insert the fines payment made by borrowers when returning the books, the date of payment made and generate the receipt for the payment. Fines Payment Page 6 of 8
2.6 User Information Page When users click on the User menu in the menu list page, it will show this user information page. In this page, users can see all the registered user's information. This page consists of: Functions Users Details Search Descriptions This function consists of all the details about registered users (display data: username, staff name, staff id, phone number). This function allows users to search the staff id or username and the details information of the user will be displayed in the same page. Allow users to update existing users' information and details. This function allows users to delete the existing user's information in the system This function shows the list of all users that have registered in the system To exit this page and return to the menu list page Update Delete List of User's Return 3.0 Database For the database of this system, il consists of all of the below tables: Functions Descriptions User This table stores all the data for the registered users in the system (date stored: staff name, staff id, phone number, user name and password) Book This table stores all of the information and details about the book that are provided in the library (data stored: ISBN, year of publication, book title, author, publisher name, category of book) Borrower This table stores all of the borrower's information and details (data stored: borrowers name, IC, phone number, address) Borrow This table stores all of the information about books that have been borrowed by borrower (data stored: book id, borrower id, issue date, duc date, retum date, late return date status: ves or no) Late Return Fines This table stores all of the information about the late return fines for the borrower (data stored: borrow id, late retum fines, payment, date of payment) Page 7 of 8