A

Project Report
on
“BOOK STORE MANAGEMENT”
Submitted in the partial fulfillment of the requirement for award the degree of

Bachelor of Technology
in
Computer Science & Engineering

Submitted To: Submitted By:

DR. NITIN Aashik(8069466
Assistant Professor Aashish(8069467)
Dept. of CSE Kunal Vats(8069501)
B.Tech. CSE 7th SEM

Department of Computer Science and Engineering

Ganga Institute of Technology & Management
Kablana, Jhajjar-124104 (Haryana)
December-2024
 CERTIFICATE

This is to certify that the work embodied in this project entitled “BOOK STORE MANAGEMENT ” is
original and has been carried out by Aashik and 8069466, Aashish and 8069467, Kunal Vats Name and
8069501 in the partial fulfillment for the award of the degree of Bachelor of Technology in Computer Science
and Engineering, Ganga Institute of Technology and Management, Kablana, Jhajjar, Haryana, is a bonafide
record of the candidate’s own work carried out by him under the supervision of DR. NITIN The work has not
been submitted, in part or in full, for any other degree or diploma of this or any other university.

Aashik(8069466)
Aashish(8069467)
Kunal Vats(8069501)
Department of Computer Science and Engineering
Ganga Institute of Technology and Management, Kablana-1241004

DR NITIN
Assistant Professor
Department of Computer Science and Engineering
Ganga Institute of Technology and Management, Kablana-1241004
 DECLARATION

We hereby declare that the project work entitled “BOOK STORE MANAGEMENT” has been carried out by
us at the Department of Computer Science and Engineering, Ganga Institute of Technology and Management,
Kablana. The project submitted for consideration of award of Bachelor of Technology is original and free
from any form of falsification and plagiarism. This work has not been submitted for similar purpose anywhere
else.
We shall be solely responsible for any dispute arising out of my project work.

Aashik(8069466)
Aashish(8069467)
Kunal Vats(8069501)
Department of Computer Science and Engineering
Ganga Institute of Technology and Management,
Kablana-1241004
 ACKNOWLEDGEMENTS

It is both an elevating and humbling experience to acknowledge all the people involved in this work. Many
individuals have contributed to this project work with their advice, interest, time and support. They are the
wind beneath my wings. We thank almighty for his compassion and bountiful blessings for making everything
possible.

We would specially like to thank our worthy guide (Guide Name>, assistant professor, department of computer
science and engineering who supervised us to complete this project. His technical advice, ideas and
constructive criticism contributed to the success of this report.He suggested us many ideas and solved our
puzzles when we were in need.His motivation and help has been of great inspiration to me.

We would also like to thank respected Dr. Nitin Kumar, HOD-CSE and faculty members of the CSE
department for providing us the opportunities, support and necessary help to complete this project work.

Aashik(8069466)
Aashish(8069467)
Kunal Vats(8069501)
Department of Computer Science and Engineering
Ganga Institute of Technology and Management,
Kablana-1241004
 ABSTRACT

Online Book Store Management System is a system which maintains the information about the books
present in the store, their authors, the members of Student to whom books are issued, store staff and all.
This is very difficult to organize manually. Maintenance of all this information manually is a very complex
task. Owing to the advancement of technology, organization of an Online Store becomes much simple. The
Online Book Store Management has been designed to computerize and automate the operations performed
over the information about the members, book issues and returns and all other operations. This
computerization of Store helps in many instances of its maintenances. It reduces the workload of
management as most of the manual work done is reduced.This work aims to describe the proposed system
of Bookstore Management System for Bookshop. The development of the proposed system is to change the
manual method to computerized system. The problem arise where customer complaint as they unable to
order book through online. And for every ordering/purchasing book is recorded manually where might
cause the document missing or misplace that difficult to the staff to make references. This proposed
system aims to solve the matters and ease the staff as well as the customer and it also can save
more time. The significance of this project is to facilitate staff to manage the record of
ordering/purchasing book and customer for them to order/purchase book through online.
 CONTENTS
Certificate i
Candidate’s Declaration ii
Acknowledgements iii
Abstract iv
Contents v
List of Tables vi
Lisof Figures vii

1. INTRODUCTION 1-16
1.1 Introduction 1
1.2 Sources of Power Dissipation in CMOS Circuit 3
1.2.1 Dynamic Power Dissipation 4
1.2.2 Short Circuit Power Dissipation 5
1.2.3 Glitching Power Dissipation 7
1.2.4 Static Power Dissipation 7
1.3 Circuit Level Power Reduction Techniques 10
1.4 Motivations 11
1.4.1 Need for Portability 12
1.4.2 High Performance 12
1.4.3 Reliability 13
1.5 Objectives of the Research Work 14
1.6 Publications 14
1.6.1 International Journals (04 Articles) 14
1.6.2 International Conference (03 Articles) 15
1.6.3 Research Paper Communicated (01 Articles) 15
1.7 Thesis Organization 15
2. NAME OF SECOND CHAPTER 17-41

2.1 Introduction 34
2.2 Design of XNOR and XOR Gates 37
 LIST OF TABLES

Table Title Page

1.1 Truth table of full adder 35
1.2 Output voltage levels of proposed XNOR gate 40
1.3 Output voltage levels of 5T XNOR/XOR cell 40
2.1 Output level variations versus supply voltage for 3T XOR & 5T XNOR 43
2.2 Performance of 8T full adder 45
3.1 Power dissipation of MCML and proposed PFD 47
3.2 Transistor sizing with L = 0.18 µm 55
 LIST OF FIGURES

Figure Title Page

1.1 Circuit transition (a) Dynamic charging (b) Dynamic discharging 3
1.2 Short circuit current 4
1.3 Leakage current components 5
2.1 Structure of single bit full adder 35
2:1 multiplexer circuit with (a) Pass transistor logic (b) Transmission
2.2 36
gate
2.3 Design of proposed 3 transistors XNOR gate 39
 CHAPTER 1
INTRODUCTION

This chapter gives an overview about the aim , objectives ,background and operation
environment of the system.

1.1 PROJECT AIMS AND OBJECTIVES

The project aims and objectives that will be achieved after completion of this project are discussed in this
subchapter. The aims and objectives are as follows:
• Online book reading.
• A search column to search availability of books.
• Facility to download required book.
• Video tutorial for students.
• An Admin login page where admin can add books, videos or page sources
• Open link for Learning Websites

1.2 BACKGROUND OF PROJECT

E-Library Management System is an application which refers to library systems which are generally small
or medium in size. It is used by librarian to manage the library using a computerized system where he/she
can add new books, videos and Page sources.

Books and student maintenance modules are also included in this system which would keep track of the
students using the library and also a detailed description about the books a library contains. With this
computerized system there will be no loss of book record or member record which generally happens when
a non computerized system is used.

All these modules are able to help librarian to manage the library with more convenience and in a more
efficient way as compared to library systems which are not computerized.

PROCESSOR INTEL CORE PROCESSOR OR BETTER PERFORMANCE

OPERATING SYSTEM WINDOWS VISTA ,WINDOWS7, UBUNTU

MEMORY 1GB RAM OR MORE

HARD DISK SPACE MINIMUM 3 GB FOR DATABASE USAGE FOR FUTURE

DATABASE MY SQL
 CHAPTER 2

SYSTEM ANALYSIS
In this chapter, we will discuss and analyze about the developing process of Library Management
System including software requirement specification (SRS) and comparison between existing and
proposed system . The functional and non functional requirements are included in SRS part to
provide complete description and overview of system requirement before the developing process is
carried out. Besides that, existing vs proposed provides a view of how the proposed system will be
more efficient than the existing one.

2.1 SOFTWARE REQUIREMENT SPECIFICATION

2.1.1 GENERAL DESCRIPTION

PRODUCT DESCRIPTION:

Library Management System is a computerized system which helps

user(librarian) to manage the library daily activity in electronic format. It reduces
the risk of paper work such as file lost, file damaged and time consuming.

It can help user to manage the transaction or record more effectively and time- saving.

PROBLEM STATEMENT:

The problem occurred before having computerized system includes:

• File lost

When computerized system is not implemented file is always lost because of human
environment.Some times due to some human error there may be a loss of records.
• File damaged When a computerized system is not there file is always lost due to some accdent like
spilling of water by some member on file accidentally. Besides some natural disaster like floods or fires
may also damage the files.

• Difficult to search record

When there is no computerized system there is always a difficulty in searching of records if the
records are large in number .
• Space consuming

After the number of records become large the space for physical storage of file and records also
increases if no computerized system is implemented.
• Cost consuming

As there is no computerized system the to add each record paper will be needed which will
increase the cost for the management of library.

2.1.2 SYSTEM OBJECTIVES

• Improvement in control and performance

The system is developed to cope up with the current issues and problems of library .The

system can add user, validate user and is also bug free.

• Save cost

After computerized system is implemented less human force will be required to maintain
the library thus reducing the overall cost.
• Save time

Librarian is able to search record by using few clicks of mouse and few search keywords thus
saving his valuable time.
• Option of online Notice board

Librarian will be able to provide a detailed description of workshops going in the college as
well as in nearby colleges
• Lecture Notes

Teacher have a facility to upload lectures notes in a pdf file having size not more than 10mb

2.1.3 SYSTEM REQUIREMENTS

2.1.3.1 NON FUNCTIONAL REQUIREMENTS

Product Requirements

EFFICIENCY REQUIREMENT
When a library management system will be implemented librarian and user will easily acess
library as searching and book transaction will be very faster .

RELIABILITY REQUIREMENT

The system should accurately performs member registration ,member validation , report generation,
book transaction and search

USABILITY REQUIREMENT

The system is designed for a user friendly environment so that student and staff of library can
perform the various tasks easily and in an effective way.

ORGANIZATIONAL REQUIREMENT IMPLEMENTATION REQUIREMNTS

 In implementing whole system it uses html in front end with php as server side scripting language
which will be used for database connectivity and the backend ie the database part is developed using
mysql.

DELIVERY REQUIREMENTS

The whole system is expected to be delivered in six months of time with a weekly evaluation by
the project guide.

2.1.3.2 FUNCTIONAL REQUIREMENTS

1. NORMAL USER

1.1 USER LOGIN

Description of feature

This feature used by the user to login into system. They are required to enter user id and password before
they are allowed to enter the system .The user id and password will be verified and if invalid id is there user
is allowed to not enter the system.

Functional requirements

-user id is provided when they register

-The system must only allow user with valid id and password to enter the system
-The system performs authorization process which decides what user level can acess to.
-The user must be able to logout after they finished using system.

1.2 REGISTER NEW USER

Description of feature

This feature can be performed by all users to register new user to create account.

Functional requirements

-System must be able to verify information

-System must be able to delete information if information is wrong

1.3 REGISTER NEW BOOK

Description of feature

This feature allows to add new books to the library

 Functional requirements

-System must be able to verify information

-System must be able to enter number of copies into table.

- System must be able to not allow two books having same book id.

1.5 SEARCH BOOK

DESCRIPTION OF FEATURE
This feature is found in book maintenance part . we can search book based on book id , book name ,
publication or by author name.

Functional requirements

- System must be able to search the database based on select search type

- System must be able to filter book based on keyword enterd

- System must be able to show the filtered book in table view

Functional requirements

-System should be able to add detailed information about events .

-System should be able to display information on notice board available in the homepage of site

2.1.4 SOFTWARE AND HARDWARE REQUIREMENTS

This section describes the software and hardware requirements of the system
2.1.4.1 SOFTWARE REQUIREMENTS

• Operating system- Windows 7 is used as the operating system as it is stable and supports more
features and is more user friendly
• Database MYSQL-MYSQL is used as database as it easy to maintain and retrieve records by
simple queries which are in English language which are easy to understand and easy to write.
• Development tools and Programming language- HTML is used to write the whole code and
develop webpages with css, java script for styling work and php for sever side scripting.

2.1.4.2 HARDWARE REQUIREMENTS

Intel core i5 generation is used as a processor because it is fast than other processors an provide
reliable and stable and we can run our pc for longtime. By using this processor we can keep on
developing our project without any worries.
Ram 1 gb is used as it will provide fast reading and writing capabilities and will in turn support
in processing.
Existing System:

◼ Early days Libraries are managed manually. It required lot of time to record or to retrieve the
details. The employees who have to record the details must perform their job very carefully.
Even a small mistake would create a lot of problems. Security of information is very less. Report
generations of all the information is very tough task.
◼ Maintenance of Library catalogue and arrangement of the books to the catalogue is very complex
task. In addition to its maintenance of member details, issue dates and return dates etc. manually
is a complex task.
◼ All the operations must be performed in perfect manner for the maintenance of the library with
out any degradation which may finally result in the failure of the entire system.

Proposed System:
To solve the inconveniences as mentioned in the existing system, an Online Library is proposed.
The proposed system contains the following features:
 The students will register them through Online
 Individually each member will have his account through which he can access the
information he needs.
 Book details like authors, number of copies totally maintained by library, present
available number of books, reference books, non-reference books etc. all this information
can be made handy.
 Regarding the members designation, number of books was issued.
 Issue dates and returns of each member is maintained separately and fine charged if there
is any delay in returning the book.
 Administrator can add, update the books.
 Time consuming is low, gives accurate results, reliability can be improved with the help
of security.

2.3 SOFTWARE TOOLS USED

The whole Project is divided in two parts the front end and the back end.

2.3.1 Front end

The front end is designed using of html , Php ,css, Java script

HTML- HTMLorHyper Text Markup Languageis the main markuplanguage for creating
web pages and other information that can be displayed in a web browser.HTML is written in
the form of HTML elements consisting of tags enclosed in angle brackets (like <html>), within
the web page content. HTML tags most commonly come in pairs like <h1> and </h1>,
although some tags represent empty elements and so are unpaired, for example <img>. The first
tag in a pair is the start tag, and the second tag is the end tag (they are also called opening tags
and closing tags). In between these tags web designers can add text, further tags, comments
and other types of text-based content. The purpose of a web browser is to read HTML
documents and compose them into visible or audible web pages. The browser does not display
the HTML tags, but uses the tags to interpret the content of the page.HTML elements form the
building blocks of all websites. HTML allows images and objects to be embedded and can be
used to create interactive forms. It provides a means to create structured documents by
denoting structural semantics for text such as headings, paragraphs, lists, links, quotes and
other items. It can embed scripts written in languages such as JavaScript which affect the
behavior of
HTML web pages.

CSS- Cascading Style Sheets(CSS) is a style sheet language used fordescribing the look
and formatting of a document written in a markup language. While most often used to style
web pages and interfaces written in HTML and XHTML, the language can be applied to any
kind of XML document, including plain XML, SVG and XUL. CSS is a cornerstone
specification of the web and almost all web pages use CSS style sheets to describe their
presentation.CSS is designed primarily to enable the separation of document content from
document presentation, including elements such as the layout, colors, and fonts. This
separation can improve content accessibility, provide more flexibility and control in the
specification. of presentation characteristics, enable multiple pages to share formatting, and
reduce complexity and repetition in the structural content (such as by allowing for table less
web design).CSS can also allow the same markup page to be presented in different styles for
different rendering methods, such as on-screen, in print, by voice (when read out by a speech-
based browser or screen reader) and on Braille-based, tactile devices. It can also be used to
allow the web page to display differently depending on the screen size or device on which it
is being viewed. While the author of a document typically links that document to a CSS file,
readers can use a different style sheet, perhaps one on their own computer, to override the one
the author has specified. However if the author or the reader did not link the document to a
specific style sheet the default style of the browser will be applied.CSS specifies a priority
scheme to determine which style rules apply if more than one rule matches against a particular
element. In this so-called cascade, priorities or weights are calculated and assigned to rules,
so that the results are predictable.

JAVA SCRIPT- JavaScript(JS) is a dynamic computer programminglanguage. It is most

commonly used as part of web browsers, whose implementations allow clientside scripts to
interact with the user, control the browser, communicate asynchronously, and alter the
document content that is displayed. It is also being used in server-side programming, game
development and the creation of desktop and mobile applications. JavaScript is a prototype-
based scripting language with dynamic typing and has first-class functions. Its syntax was
influenced by C. JavaScript copies many names and naming conventions from Java, but the
two languages are otherwise unrelated and have very different semantics. The key design
principles within JavaScript are taken from the Self and Scheme programming languages. It is
a multiparadigm language, supporting object-oriented, imperative, and functional
programming styles. The application of JavaScript to use outside of web pages—for example,
in PDF documents, site-specific browsers, and desktop widgets—is also significant. Newer and
faster JavaScript VMs and platforms built upon them (notably Node.js) have also increased the
popularity of JavaScript for server-side web applications. On the client side, JavaScript was
traditionally implemented as an interpreted language but just-in-time compilation is now
performed by recent (post-2012) browsers.
 PHP- PHPis a server-side scripting language designed for webdevelopment but also used as a
general-purpose programming language. PHP is now installed on more than 244 million
websites and 2.1 million web servers. Originally created by Rasmus Lerdorf in 1995, the
reference implementation of PHP is now produced by The PHP Group. While PHP originally
stood for Personal Home Page, it now stands for PHP: HypertextPreprocessor, a recursive
backronym.PHP code is interpreted by a webserver with a PHP processor module, which
generates the resulting web page: PHP commands can be embedded directly into an HTML
source document rather than calling an external file to process data. It has also evolved to
include a command-line interface capability and can be used in standalone graphical
applications. PHP is free software released under the PHP License. PHP can be deployed on
most web servers and also as a standalone shell on almost every operating system and
platform, free of charge.

MYSQL- MySQL("My S-Q-L", officially, but also called "My Sequel") is (as ofJuly 2013) the
world's second most widely used open-source relational database management system (RDBMS).
It is named after co-founder Michael Widenius daughter, MySQL phrase stands for Structured
Query Language. The MySQL development project has made its source code available under the
terms of the GNU General Public License, as well as under a variety of proprietary agreements.
MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB,
now owned by Oracle Corporation .MySQL is a popular choice of database for use in web
applications, and is a central component of the widely used LAMP open source web application
software stack (and other 'AMP' stacks). LAMP is an acronym for "Linux, Apache, MySQL,
Perl/PHP/Python." Free-software-open source projects that require a full-featured database
management system often use MySQL. For commercial use, several paid editions are available,
and offer additional functionality. Applications which use MySQL databases include: TYPO3,
MODx, Joomla, WordPress, phpBB, MyBB, Drupal and other software. MySQL is also used in
many high-profile, large-scale websites, including Wikipedia, Google (though not for searches),
Facebook, Twitter, Flickr, and YouTube.
 CHAPTER 3

SYSTEM DESIGN

3.1 TABLE DESIGN

VARIOUS TABELS TO MAINTAIN INFORMATION
Library Table from Database

Admin Table from Database

 Subjects Table from Database

Books Table from Database Books Table from Database

Videos Table from Database




Open link Table from Database


3.2 DATA FLOW DIAGRAM

DATA FLOW DIAGRAM FOR ASMIN LOGIN

After entering to the home page of the website , Admin can choose the Admin Login option where they
are asked to enter username & password , and if he/she is a valid user then a teacher login page will be
displayed.

USE CAESE DIAGRAM FOR USER

After entering to the home page of the website , student can choose the USER LOGIN option where they
are asked to enter username & password , and if he/she is a valid user then a student login page will be
displayed.
DATA FLOW DIAGRAM FOR USER

USER CASE DIAGRAM FOR ADMIN

SEQUENCE DIAGRAM
24
 25

SYSTEM IMPLEMENTATION
4.1 Screenshot for homepage

4.2 Screenshot of e-books from user.

 26

4.3 Screenshot of videos from user

4.4 Screenshot of open-link from user

 27

4.5 Screenshot of login for admin

4.6 Screenshot of e-book from admin

 28

4.7 Screenshot of videos from admin

4.8 Screenshot of open-link from admin

 29

4.9 Screenshot of subjects from admin

5.0 Screenshot of settings from admin

 30

5.1 MODULE DESCRIPTION

For Library Management System it is divided into the following Modules:

 31

CHAPTER 5 SYSTEM TESTING

The aim of the system testing process was to determine all defects in our project .The
program was subjected to a set of test inputs and various observations were made and based
on these observations it will be decided whether the program behaves as expected or not. Our
Project went through two levels of testing

1.Unit testing

2.integration testing

UNIT TESTING
Unit testing is undertaken when a module has been created and succesfully reviewed .In order
to test a single module we need to provide a complete environment ie besides the module we
would require

• The procedures belonging to other modules that the module under test calls

• Non local data structures that module accesses

• A procedure to call the functions of the module under test with appropriate
parameters

Unit testing was done on each and every module that is described under module description of
chapter 4

1. Test For the admin module

• Testing admin login form-This form is used for log in of administrator of the
system.In this we enter the username and password if both are correct
administration page will open other wise if any of data is wrong it will get
redirected back to the login page and again ask for username and password
 32

• Student account addition- In this section the admin can verify student details
from student academinc info and then only add student details to main library
database it contains add and delete buttons if user click add button data will be
added to student database and if he clicks delete button the student data will be
deleted
• Book Addition- Admin can enter details of book and can add the details to the
main book table also he can view the books requests .

2. Test for Student login module

• Test for Student login Form-This form is used for log in of Student .In this
we enter thelibraryid, username and password if all these are correct student
login page will open other wise if any of data is wrong it will get redirected
back to the login page and again ask for libraryid, username and password.
• Test for account creation- This form is used for new account creation when
student does not fill the form completely it asks again to fill the whole form
when he fill the form fully it gets redirected to page which show waiting for
conformation message as his data will be only added by administrator after
verification.
3. Test for teacher login module-

Test for teacher login form- This form is used for logg in of teacher .In this we enter the
username and password if all these are correct teacher login page will open other wise if any of
data is wrong it will get redirected back to the login page and again ask for username and
password.

INTEGRATION TESTING

In this type of testing we test various integration of the project module by providing the input

.The primary objective is to test the module interfaces in order to ensure that no errors are
occurring when one module invokes the other module.
 33

CHAPTER 6
CONCLUSION & FUTURE SCOPE

This website provides a computerized version of library management system which will
benefit the students as well as the staff of the library.

It makes entire process online where student can search books, staff can generate reports and
do book transactions. It also has a facility for student login where student can login and can see
status of books issued as well request for book or give some suggestions. It has a facility of
teacher’s login where teachers can add lectures notes and also give necessary suggestion to
library and also add info about workshops or events happening in our college or nearby college
in the online notice board.

There is a future scope of this facility that many more features such as online lectures video
tutorials can be added by teachers as well as online assignments submission facility , a feature Of
group chat where students can discuss various issues of engineering can be added to this project
thus making it more interactive more user friendly and project which fulfills each users need in
the best way possible.