A REPORT

ON
“LIBRARY MANAGEMENT SYSTEM”

BACHELOR OF COMPUTER APPLICATION

SUBMITTED TO
C.C.S. UNIVERSITY, MEERUT

Page 1
1.1Statement about the problem

1.2 Why is the particular topic chosen?

1.3 Methodology

1.4Scope

1.6 Hardware & Software to be used – Server, Clients, Back

end, Tools, Software platform, programming language etc.

1.7 Your role in the project.

1.8 Testing technologies and Security Mechanisms

1.9 What contribution would the project make?

 1.10 Limitations

 1.11 Conclusion

1.12 Reference

Page 2
STATEMENT ABOUT THE PROBLEM

Page 3
 Now a day every field wants a computerized system for the better
performances of their work. The computerized system, all the information
will be carried out in the same way as the manual system but so many
aspects.

The manual system is time consuming because of less work efficiency

in comparison to machine and also it need much paper work that is a big
problem and there may be possibilities of errors.

The computer system proposed is beneficial more powerful, hang

accuracy and speed and it remove the problem related with manual system.

The main of “LIBRARY INFORMATION SYSTEM” is as follows:

1. Information of members.
2. Information of books.
3. Information of issuing detail.
4. Elimination of manual labor.
.

Page 4
Page 5
We havocs and chosen this project because Library is the most used department of college by
student where automation is required because it is very important to keep record of all books
and student who have taken the book

Page 6
No paper work

To solve actual problems in a industry setting, a software engineer (or the team)

must incorporate a development strategy that encompasses the process, methods

and tools. This strategy is often referred to as a process model, which is chosen

based on the nature of the project and application, the methods and tools to be

used, and the controls and deliverables that are required.

For “Hospital Staff” I have chosen an INCREMENTAL MODEL that

combines elements of the linear sequential model with the iterative philosophy

of prototyping. In an incremental mode, the first increment is often a core

product. That is, basic requirements are addresses, but many supplementary

features(some known, others unknown) remain undelivered. The core product

is used by the candidate (undergoes detailed review). This review helps in the

formation of a plant and addresses the modification of core product to better

meet the needs of customer and the delivery of additional features and

functionality. The process is repeated following delivery of each delivery of

each increment, until the complete product is produced.

Page 7
Page 8
This software is confine to a school library in meerut
which will automat the day to day working of library in
school

As we know when we work on the computer we do not need any

paper. Computers have their own memory to store data and information.
Computers can stores information which at least occupy thousands of
paper if done manually. It saves money and space.

No such maintenance for a file is needed

As we know in manual file management system needs a lot of money for
maintenance but in computerized payroll system we don’t expense more
for file management.

Error Free Calculation

As we knows in manual work there are chances of error every time
the task is done this is very to handle but in the computerized system
calculation is error free

Page 9
HARDWARE AND SOFTWARE TO BE USED

Page
10
 PROJECT REQUIREMENT

Category : - LIBERARY MANAGEMENT SYSTEM

Tools/ Platform :-

Language Software: - RDBMS and Visual Basic

Front End :- Microsoft Visual Basic 6.0

Back End :- Microsoft Access

Hardware :- Pentium or Equivalent Processor,

32MB or above RAM, 2GB or above

Hard Disk, VGA/SVGA Monitor.

Operating System : - Windows XP Service Pack 2

Page
11
role in the project

Page
12
 Vatshala:
coding
2:
Designing
3.
Data base
development and
connectivity
4:
Report making

Page
13
testing technology and
security

Page
14
Testing is the major control neasure used during software development. Its basic

function is to detect errors in the software. During requirements analysis and

design, the outut is a document that is usually textual and non-executable. After

the coding phase, computer programs are available that can be executed for

testing purposes. This implies that testing not only has to uncover errors

introduced of testing is to uncover requirement, design and codinh errors in the

programs Consequently, different levels of testing are used.

Unit Testing:-

The stating point of [Link] this module is tested separately and is often
performed by the coder himself simultaneously along with the coding of the
module. The purpose is to exercise the different part module code to
detect coding errors.

Integration Testing:-

Integration Testing is performed to detect design errors by focusing on testing

the interconnection between modules.

System Testing:-

System is tested against the system, requirements to see if all the requirements
are met and if the system performs as specified by the requirements.

Acceptance testing:-

Acceptance Testing is performed to demonstrate to the client, on the real-life

data of the client the operation of the system.

REQUIREMENT COLLECTION AND ANALYSIS

Page
15
Interviewing Personnel:- The S/w is being developed basically for use of

personnel dept. So discussions were made with the persons of the dept. To

extract out the exact requirement.

Observing The Current System:- The current system is manual and is worth

observing the current system. It helped a lot in designing the Computerized

System.

Studying similar Project on Business Managing:-The developer went to

study development of various database management system. The other software
were studied.

Page
16
WHY WE CHOOSE VISUAL BASICAS AS A FRONT END
TOOL

 Visual Basic is not just a language. It’s an IDE in which you can develop
run, test and debug your application.

 The working environment in Visual Basic is often referred to as the

integrated development environment or IDE because it integrated many
different functions such as design, editing, compiling and debugging
within a common environment.

 Visual Basic provides a great deal of flexibility, allowing user of

configure the working environment to best suit your application.

 User can choose between a single or multiple document interface and

user can adjust the size and positioning various integrated development
environment element.

 Data access features allows users to created database front end

application and scalable server side component for most popular database
formats, including Microsoft SQL server and other database.

Page
17
 INTRODUCTION TO MS-ACCESS

It is a coherent of data with some inherent meaning. Design cast and populated
with data for a specific purpose. A data base stores data that is useful to us. This
data is only part of the entire data available in the world around us.

To be able to successfully design and maintain database we have to do the

following:-
 Identify which part of the world data is of interest to us.
 Identify what specific objects in that part of world data are of
interests to us.
 Identify a relationship between the object.

Hence, the objects, their tributes and the relationship between them that are to
us are stored in database that is designed, build and populated data for a specific
purpose.

MS Access is developed by Microsoft according to above consideration. MS

Access a powerful tool of MS Office which allow user to create database and
also have ability to maintain a database.

Page
18
 WHY WE CHOOSE MS-ACCESS AS A BACK END TOOL?

Microsoft access is a powerful relation data base management (RDBMS),

because it can establish between two or more data base and table very easily.

Microsoft access is a user friendly-program, Microsoft access can be used

to store large amount of data for examples student’s records, employments
records, and inventory records etc.

MS-Access helps to create database table, enter new records, delete

desired records, relation between its table and get the print very easily. In MS-
Access we can create reports and mailing labels on based of data base table.

Page
19
SYSTEM FLOW CHART

Page
20
 SYSTEM FLOW CHART

No
Login Form EXIT

O
K

LIBRARY
MANAGEMENT SYSTEM

DISPLAY ALL FORMS

OUTPUT

EXIT

Page
21
 MEMBER MENU
FLOWCHART

START

Click on member
menu on main form.

1. Detail
2. Add
3 3. Delete 1
Display
x
Member
Details

2 Back
Displays delete
member form

Display
Main
Form
y

Page
22
 X

INPUT DETAILS
FOR MEMBER

Want to add?
yes Add
record

no

Display main form

Page
23
 y

Display
Delete
Member
Form

Enter record
of
Member to be deleted

Want to
delete
yes Delete
record

no
Display main form

Page
24
 ADD CADIDATE
FLOWCHART

Start

Display Record

If No
Add

Exit

Yes

Accept Information

If
Save No

Yes
Record File

Page
25
 DELETE CANDIDATE
FLOWCHART
Start

Display Record

If No
Delete

Exit

Yes

Accept record to be deleted

If
Save No

Yes
Record File

Page
26
 SEARCHING FLOWCHART

Start

If by If By
Member ID no. No Member Name No

Yes Yes

Display Record Display Record

by Member ID no. byYes
Member Name

Exit

Page
27
LIBRARY FLOWCHART

Start

Display Massage
For New Member

Accept New Member

Data Processing

Display All Member list

Exit

Page
28
 Start

Accept Code

If
Valid

Call Application
Exit

Page
29
ENTITY RELATIONSHIP
DIAGRAM

Page
30
 ENTITY RELATION DIAGRAM

ADDRESS

MEMBER
NAME MEMBER
FEES

MEMBER MEMBER RENEWL

CODE DATE

BOOK ISSUE &

RETURN

RACK NO.
BOOK NAME BOOK

CODE AUTHOR

STOCK PUBLISHER

Page
31
DATA FLOW DIAGRAM

Page
32
 Data entry
Program

Library
Transaction

Library
Program

Report

Page
33
 TRANSACTION

Collect
Members Data

Library
Program

REPORT

Report Add

Page
34
 DATA FLOW DIAGRAM

Is book ISSUE
MEMBER already DATABASE
Issued
or not

request to
issue book Yes/No
Book issued
Y/N
BOOK ISSUE
PROCESS

Is book
Available/ not

Y/
N

Update

BOOK
DATABASE

MEMBER
CODE
Page
35
MEMBER
NAME

LIBRARY
ADDRESS

LIBRARY
MEMBER
FEES

RENEWEL
DATE REPORT

BOOK CODE

BOOK NAME

AUTHER

PUBLISHER

RECK NO.

Page
36
 what contribution would the project make

Fast working Procedure

Computer are fast and usually do most of the work in second this not
only increase our speed increase but also helps users to get theirs work
done easily and also saves theirs time .

No paper work

As we know when we work on the computer we do not need any

paper. Computers have their own memory to store data and information.
Computers can stores information which at least occupy thousands of
paper if done manually. It saves money and space.

No such maintenance for a file is needed

As we know in manual file management system needs a lot of money for
maintenance but in computerized payroll system we don’t expense more
for file management.

Error Free Calculation

As we knows in manual work there are chances of error every time
the task is done this is very to handle but in the computerized system
calculation is error free

Page
37
 LIMITATION

We have put our almost effort in this project but we found the following
limitation in it:

 Due to shortage of time we were unable to incorporate all the feature

of library management system.
 Less security levels.
 Dose not support DOS mode
 No on line facility.

Page
38
CONCLUSION

Page
39
 CONCLUSION

We can not say our work is 100% complete. There is always space for
rectification and modification. So there fore, in this library management
system all the drawback of manual system have been removed and the
efficiency of the system has been improved up to the maximum extent.
Generally manual system are very time consuming and so work or inquiry
can be performed instantly, but here by working on the computer overall
efficiency of the system increase a lot every task is done instantly. In this
system a large database can be maintained easily. This system is very user
friendly, so therefore it can be handled easily just by carry training.

Page
40
references
[Link] In Visual [Link] – Bpp Publication

[Link] Book – Dreamtech Press

[Link] Basic In 21 Days – Bpp Publication

[Link] And Design Of Information System Phi [Link]

[Link] Engineering Pankaj Jalote

[Link] Pro In Vb, Wrox

Page
41