SRISHTI WORLD SCHOOL
INFORMATION TECHNOLOGY (402)
“Online book issue system”
{Session 2024-25}
Submitted by:
Roll no:
Class: 10th
Date:
{Subject Teacher}
ACKNOWLEDGEMENT
It gives me immense pleasure to present this project report on “Online Book
Issue System”. This project work consists of Libra Base which are a useful
DBMS and a part of Libra Office base. In this report, a database file has been
made upon the “Online book issue system.”
I would like to thank our Information Technology faculty, who always guided
me in our proceedings. I am also thankful to my friends who have helped me.
ACHIEVEMENT CERTIFICATE
This is to certify that (……………………….) of CLASS X, Roll no:…………….. of
Srishti world School has satisfactorily completed her“Book Issue System”
project in Information Technology (402) for the session 2024-2025.
Date:
V Rama Devi(IT Teacher)
INDEX
Sl. no Topic
1 Introduction
2 Synopsis
3 Libra Office Base
Project Database
4 Table structure
#book
#student
#issue / return
5 Screenshot of table structure
6 Screenshots of forms
7 Screenshots of reports
8 Screenshots of queries
9 Conclusion
INTRODUCTION:
Books play a vital role in learning across all the ages. The usual sources of the
books are the library. With the pandemic in place, it has become very difficult
to get the books issued and read them in Library premises. To overcome this
issue, in this project we propose an “Online Book Issue System” to enable the
learners to get the books in time and get benefited.
Online Library Management System is Automated Library System that
handles the various functions of the library. It provides a complete solution to
the Library Management system. The online management system is classified
into two parts Barcode System and RFID System.
SYNOPSIS:
The Online Book Issue System is a platform that helps the learners to identify
the list of books available in the repository. The learner who is in need of
books are required to go through the list of items available in the catalog and
book them based on the availability. The books ones available will be issued
to the learner and the inventor is updated accordingly. The books can be
returned by the learner after the use through the system wherein the
learners has to enter the code of the book to be returned. The Books status
will change accordingly after the return through the update of the count of
the remaining books. Overall the Online Book Issue System acts as an
effective platform for the issue and return of the book.
Table Structure
Table name: All BOOKS DATA
Field Specifications
Field name Field Type
Book code Number(Numeric ); Primary key
Book name Text {Varchar};
Book description Text {Varchar};
Price Decimal {DECIMAL};
Stock Available Number(Numeric );
Book taken Number(Numeric );
Student _Id Number(Numeric );
Table Name :Book Data
Field Specifications
Field Name Field Type
Student_ ID Numeric {Number}; Primary Key
Student Name Text {Varchar};
Address Text {Varchar};
City Text {Varchar};
Phone Numeric {NUMBER};
Table Name: BOOKS DATA
Field Specifications
Field Name Field Type
Book_ ID Number {Numeric}; Primary Key
Issue Date Date {DATE/TIME};
Book Type Text {VARCHAR};
City Text {VARCHAR};
Quantity Number {Numeric};
Creating database:
Setting a primary key:
Creating table BOOKS DATA IN DESIGN VIEW:
SAVING THE TABLE:
CREATING TABLE STUDENT DATA:
Creating table BOOKS ISSUE DATA (Issue /RETURN):
CREATING FORMS FOR STUDENT DATA
CREATING FORMS FOR BOOK ISSUE DATA:
CREATING FORMS FOR BOOKS DATA :
Creating reports for table Books Data
CREATING REPORTS FOR TABLE BOOKS issue DATA :
Creating reports for student table:
Screen shots of queries: {Books Data}
Screen shot of queries: {Books issue Data}
Screen shots of queries: {student Data}
Conclusion:
I have learnt about online book issue system, which helps to get books in time
to be benefited. We have learnt to represent the information through
database.
Online Book Issue System is much more user-friendly, faster in operation and
easy to manage than the manual one. Through the use of it, the librarian can
manage the whole data of the library in a single database in different tables
with a much more security than the traditional way.