Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Give me the all the coding code and all the project vb files(if can) You are required to write a full program code for Library

image text in transcribedimage text in transcribed

image text in transcribedimage text in transcribed

image text in transcribedimage text in transcribed

Give me the all the coding code and all the project vb files(if can)

You are required to write a full program code for Library Management System based on the information provided ReadOBrite Public Library just started its operation. Funded by the 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 requirements for the system are explained in details as below. 1.0 Start-up Page First of all, the system needs to have a start-up page for the librarian. This page consists of: Functions Descriptions This is the logo of the library which your group Library logo 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. Exit button To exit this start-up page. 1.1 Registration Page For the registration page, new users (the librarians) need to input all the information details: Input Details Name Staff ID Phone number Username Descriptions Name of the librarian that want to register a new account in this system. The librarian need to input the staff ID, which consists of strings and numbers (ex: ROB200001). 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). CONFIDENTIAL Password Message box 1.2 Login Page For the login page, the existing users (the librarians) need to input all the information details: Input Details Username Password Descriptions Insert the existing username. Insert the existing password. Display a message for validation if the user entered the wrong username or password. Message box 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 Lists Books Details Borrowers Book Issue Descriptions This is the menu button to redirect user to the books details page that consists all of the books information provided in the library. This is the menu button to redirect user to the borrower's details page that consists information about the borrower. 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 want to borrow the book. This is the menu button to redirect user to the book return information page, which consists of information about the book that have been returned. This is the menu button to redirect user to the late return information page that consists information about the late return of the book. This is the menu button to redirect user to the user information page that consists the information about all the users of the system. Display the current user that have login into the system, current date and time To exit this page. Book Return Late Return User Login information Exit button 2.1 Books Details Page When users click on the Books menu in the menu list page, it will show this books details page. This page consists of all of bellow 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 allow users to add a new book details 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 Delete 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 bellow functions: Functions Borrower's Details Group Box Search Add Descriptions This function consists of all the details (text fields) about borrowers (display data: borrower's name, IC, phone number, address, no. of books borrow 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 borrower name, IC, phone number, address). Allow users to update existing borrower's information and details. This function allows users to delete the existing borrower's information in the system. This function shows the list of all books that have been borrow which consists of data about book borrowed (ISBN, year of publication, book title, author, publisher name, date borrowed, date returned, no. of overdue days, late return fines) To exit this page and return to the menu list page. Update Delete List of Books Borrow Return 2.3 Book Issue Information Page When users click on the Book Issue menu in the menu list page, it will show this book issue information page. In this page, users need to enter all the information needed when people want to borrow books from this library. This page consists of: Input Details ISBN Book Title Borrower's Name Descriptions These text fields are auto generated (user cannot input the data in it) from a search button, where users need to search the information based on ISBN, author or title (user can choose either one) and when user selected the existing book data, the ISBN number and book title data will be displayed in these both text fields. This text field is also auto generated (user cannot input the data in it) from a search button, where users need to search the borrower's name in the existing borrowers data and when user selected the existing borrowers data, the borrower's name will be displayed in the text field. However, if the borrower's name is not existed, add button will be enabled that redirect users to the Borrowers Information Page to add new borrowers information Allow users to enter current date or the start date when the borrower want to borrow the books. Allow users to enter the due date of the borrowing process (usually borrower can borrow the books in a week only). User need to click this button to insert the data into the database. To exit this page and return to the menu list page. Issue Date Due Date Book Issue button Return button 2.4 Book Return Information Page When users click on the Book Retum menu in the menu list page, it will show this book return information page. In this page, users need to search the borrower's information and insert the returned details when people return the books that they have borrowed from this library. This page consists of: Functions Descriptions Borrower's Name These text fields are auto generated (user cannot input the data in it) from a search button, where users need to search the borrower's name in the existing borrowers data and when user Borrower's IC Number selected the existing borrowers data, the borrower's name and IC will be displayed in the text fields. This list allows users to tick which books that the borrower List of Books Borrowed (with want to return (display data: ISBN, year of publication, book checkboxes for each of the title, year of publication, author, publisher name, issue date, data in the lists) 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 Return 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 Return button 2.5 Late Retum 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 the books that have not been returned yet and the late return fines information. This page consists of: Functions List of Late Return Books Descriptions This list display all of the book information that have not been returned yet (display data: Borrower's name, IC, phone number, ISBN, year of publication, book title, year of publication, author, publisher name, issue date, due date, late return fines). 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 users 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. Search Fines Payment 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 users' information. This page consists of: Functions User's Details Group Box Search Descriptions This function consists of all the details (text fields) about registered users (display data: username, staff name, staff id, phone number). This function allows users to search the user based on staff id or username and the details information of the user will be displayed in the same page. Allow users to update existing user's 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 Users Return 3.0 Database For the database of this system, it consists of all of the below tables : Database Tables Descriptions User This table stores all the data for the registered users in the system (data stored : staff name, staff id, phone number, username and password). This table stores all of the information and details Book about the book that are provided in the library (data stored: ISBN, year of publication, book title, author, publisher name, category of the book). Borrower This table stores all of the borrower's information and details (data stored : borrower's name, IC, phone number, address). This table stores all of the information about books Borrow that have been borrowed by borrower (data stored book id, borrower id, issue date, due date, return date, late return status: yes or no) This table stores all of the information about the late Late Return Fines return fines for the borrower (data stored : borrow id, late return fines, payment, date of payment)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Describe how to train managers to coach employees. page 404

Answered: 1 week ago

Question

Discuss the steps in the development planning process. page 381

Answered: 1 week ago