Download Library Management System: A Thesis for Master of Computer Science and more Thesis Computer Science in PDF only on Docsity!
LIBRARY MANAGEMENT SYSTEM
A thesis submitted to
Institute of Computing and Information Technology
Gomal University, Dera Ismail Khan
In Partial Fulfillment
Of the requirements for the degree of
Master of computer science (MCS)
By:
Aziz Ullah Khan
Rizwan Ullah Khan
Irfan Ullah Khan
Session 2016-
INSTITU
TE OF
COMPUT
ER AND
Dedication
To
The Prophet of Mercy (Peace Be Upon Him)
And To
Our Honorable Parents, Respected Teachers and friends whose support
Have given us the strength Determination
& Fortitude to Accomplish Our Goal.
They all are Assets of Our Life.
APROVAL CERTIFICATE
This is to certify that Mr.Aziz Ullah Khan, Mr.Rizwan Ullah Khan and Mr.Irfan Ullah Khan
and Has Been Successfully completed their Project at the Institute of computing and information
technology, Gomal University D.I.Khan. Project report submitted by Mr. Aziz Ullah Khan,
We are also indebted to our loving parents, who have always helped keep us feet planted firmly
on the ground and without whose affection, support and prayers we could not have completed
my project.
We are thankful to our director Jamal Abdul Nasir for very much cooperation.
Last But not least, I express my sincere regards to all of our respectable teachers.
Aziz Ullah Khan
Rizwan Ullah Khan
Irfan Ullah Khan
Session 2016-
PREFACE
Almost all the reputed universities of the world have a well established library for providing
public education and research activities. As a rule the number of books, journals and magazines
etc that such libraries possess represent the level of education growth of that university. Apart
from Central Library in Gomal University, Dera Ismail Khan, all the departments have been able
to develop their own separate libraries which have good collection education staff.
Data Related to all such staff like books, journals, magazines, newspapers etc are stored
manually and so retrieval of information is very slow and cumbersome. This automation project
is aimed at storing the records in a manner that reduces redundancy and supports quick access
and retrieval.
PROJECT IN BRIEF
Project Title: LIBRARY MANAGEMENT SYSTEM
Submitted by: Aziz Ullah
Khan Rizwan
Ullah
Khan &
Irfan Ullah Khan
- Starting Date: October
- Completion Date: December - SQL Management Studio Tools Used: Visual Studio 2016(VB.Net)
- Operation System: Microsoft Windows System Used: CORE i5, 4 GB RAM
- LIBRARY MANAGEMENT SYSTEM........................................................................................................ Contents
- Dedication.....................................................................................................................................................
- APROVAL CERTIFICATE...........................................................................................................................
- ACKNOWLEDGEMENTS...........................................................................................................................
- PREFACE.....................................................................................................................................................
- Chapter No.1................................................................................................................................................
- PRESENT SYSTEM...................................................................................................................................
- Introduction:
- 1.1. Structure:......................................................................................................................................
- 1.1.1. Books Stock Entry Section..................................................................................................
- 1.1.2 Issue and Return Section......................................................................................................
- 1.1.3 Registration Section.............................................................................................................
- 1.1.4 Book Lost Section................................................................................................................
- 2.1 DEFICIENCIES IN THE EXISTING SYSTEM.........................................................................
- 2.1.1 Manual work........................................................................................................................
- 2.1.2 Maintenance of various Registers and Redundancy............................................................
- 2.1.3 Assigning Accession number...............................................................................................
- 2.1.4 Catalogue Searching is Time Consuming............................................................................
- 2.1.5 Entry of Book Lost...............................................................................................................
- 2.1.6 Too Much information.........................................................................................................
- 2.1.7 Efficiency.............................................................................................................................
- 2.1.8 Old File System...................................................................................................................
- 2.1.9 Delay in response.................................................................................................................
- 2.1.10 Redundancy..........................................................................................................................
- Chapter No.2................................................................................................................................................
- Proposed System..........................................................................................................................................
- 2.1 PROPOSED SYSTEM AND ITS ADVANTAGES.....................................................................
- 2.1.1 Time Saving.........................................................................................................................
- 2.1.2 Economical Benefits............................................................................................................
- 2.1.3 Security Facility...................................................................................................................
- 2.1.4 Search Facility......................................................................................................................
- 2.1.5 Rollback Facility..................................................................................................................
- 2.1.6 Editing Facility.....................................................................................................................
- 2.1.7 Backup Facility....................................................................................................................
- 2.1.8 Publisher Entry Section........................................................................................................
- 2.1.9 Book Entry And Search Section:.........................................................................................
- 2.1.10 Program Entry......................................................................................................................
- 2.1.11 Student and Staff Section.....................................................................................................
- 2.1.12 Issue and Return Section......................................................................................................
- 2.1.13 Student and Staff Fine Section.............................................................................................
- 2.1.13.1 Tools used in propose system
- 2.1.13.2 OBJECTIVES
- Chapter No.3................................................................................................................................................
- Data Flow Diagram......................................................................................................................................
- Chapter No.4................................................................................................................................................
- Entity Relationship Diagram.......................................................................................................................
- 4.1 Conceptual Diagram....................................................................................................................
- 4.2 Logical Diagram..........................................................................................................................
- 4.3 Physical Diagram.........................................................................................................................
- DATABASE ADMINISTRATON...............................................................................................................
- Chapter No.5................................................................................................................................................
- ADMINISTRATION SECURITY MANAGEMENT.................................................................................
- 5.1 Security Management..................................................................................................................
- 5.2 Security Modes:...........................................................................................................................
- 5.3 Planning Security.........................................................................................................................
- 5.4 Database Access...........................................................................................................................
- 5.4.1 Type of Access.........................................................................................................................
- 5.4.1.1 Guest Access........................................................................................................................
- 5.4.1.2 Group Permissions...............................................................................................................
- 5.5 SECURITY OF LIBRARY MANAGEMENT SYSTEM...........................................................
- 5.5.1. Administration.........................................................................................................................
- 5.1.1.1 Backing up the data..............................................................................................................
- 5.1.1.2 Copying a Database.............................................................................................................
- 5.2 Administration of L/S..................................................................................................................
- Chapter No.6................................................................................................................................................
- TABLE DESIGN.........................................................................................................................................
- 6 Table Name: Publisher.....................................................................................................................
- 6.1 Table Name:Table Book..............................................................................................................
- 6.2 Table Name: Table Student..........................................................................................................
- 6.3 Table Name: Table Program........................................................................................................
- 6.4 Table Name: Table Staff...............................................................................................................
- 6.5 Table Name: Table Designation...................................................................................................
- 6.6 Table Name: Table IssueRetBookStd..........................................................................................
- 6.7 Table Name: Table IssueRetBookStaff........................................................................................
- 6.8 Table Name: Table FineStd..........................................................................................................
- 6.9 Table Name: Table FineStf..........................................................................................................
- Chapter No.7................................................................................................................................................
- Views Design...............................................................................................................................................
- 7.1. View of Table Publisher and Book..............................................................................................
- 7.2. View of Table Program and Student...........................................................................................
- 7.3. View of Staff and Designation.....................................................................................................
- 7.4. View Of TblissueRetBookStd,vwStudent And vwbook..............................................................
- 7.5. View Of TblissueRetBookStd,vwStaff And vwbook...................................................................
- 7.6 View of TblFineStd,vwstudent and vwbook................................................................................
- 7.7 View of TblFineStaff,vwStaff and vwbook.................................................................................
- Chapter No.8................................................................................................................................................
- FORMS.....................................................................................................................................................
- 8.1. Form Name: Main Form..............................................................................................................
- 8.2. Form Name: New Publisher.........................................................................................................
- 8.3. Form Name: New Book...............................................................................................................
- 8.4. Form Name: New Student...........................................................................................................
- 8.5. Form Name: New Program..........................................................................................................
- 8.6. Form Name: All Staff Information Entry.....................................................................................
- 8.7. Form Name: New Designation....................................................................................................
- 8.8. Form Name: Books issues to Students........................................................................................
- 8.9. Form Name: Books Issues To Staff.............................................................................................
- 8.10. Form Name: Return Book From Student.................................................................................
- 8.11. Form Name: Return Book From Staff.....................................................................................
- 8.12. Form Name: Fine Apply On Student.......................................................................................
- 8.13. Form Name: Fine Apply On Staff............................................................................................
- Chapter No.9................................................................................................................................................
- Crystal Report:.............................................................................................................................................
- Crystal Report Advantages......................................................................................................................
- Crystal Report Disadvantages..................................................................................................................
- Reports.....................................................................................................................................................
- 9.1. Report of All Publishers...............................................................................................................
- 5.1 Report of All Books.....................................................................................................................
- 9.2. Report of All Books.....................................................................................................................
- 9.3. Report of All Students..................................................................................................................
- 9.4. Report of All Programs................................................................................................................
- 9.5. Reports Of All Staff Member.......................................................................................................
- 9.6. Report of All Designation............................................................................................................
- 9.7. Report off All Issued Books to Students......................................................................................
- 9.8. Report off All Issued Books to Staff............................................................................................
- 9.9. Report of All Returned Books from Students..............................................................................
- 9.10. Report of All Returned Books from Staff................................................................................
- 9.11. Report Of All Fines Received From Students.........................................................................
- 9.12. Report of All Fine Received From Staff..................................................................................
- 9.13. Report Of Specific Book Information......................................................................................
- 9.14. Report Of Specific Student Information..................................................................................
- 9.15. Report Of Specific Staff Member............................................................................................
- 9.16. Report of Specific Books Search by Cupboard Number.........................................................
CH
APT
PRES
This section is responsible for issuing books to registered and recollect the borrowed books.
Whenever a member want to issue one or more books, his/her registration number is verified and
total number of books the member can borrow is also verified, and the books are issued to the
member , name of the issued books, there accession No. and the date of issuance are noted in a
file called issued/returned register.
2. Return
When a member returns books, the returning date is checked whether it violates the due date or
not. If the date is over, then the fine is calculated @ Rs.1 per book per day. The returning date
and signature of the member are noted in the issue/return register.
3. Registration Section.
The Registration section keeps the record of all members registered with the library and also
registers any new users.
Any User who desire to borrow books from library, is a candidate for registration. The candidate
fills in the card returns it to the registration section. The registration section note sown the date in
the registration file and assign a unique registration number to the candidate. Thus a candidate
becomes a registered member and can borrow books. The registration numbers are assigned in
serial wise manner on the basis of first-come-first-serve, and without considering department or
other details.
The procedure of registering a faculty member or admen/ministerial staff is slightly different
from registering a student.
4. Book Lost Section.
In the present system when book is lost by member. Then this thing is noted in register and fine
is estimated.
Formula for the calculating fine is:
A=Actual price
B=3(times) Actual price
C=20% university charge======== (B
Now
Total Recovered cost= B + c
OR
3 Times of actual price + ((3 tunes actual price
When the fine is collected from members then its date and Receipt No. are recorded in
register.
1. DEFICIENCIES IN THE EXISTING SYSTEM
Although the present system work if reliable and going on write well, but it can never be the
alternate of an automated system. The efficiency of tanoak work can be affected by tiredness
and boredom of the staff members. The manual system is a bit slower because it consists of
searching a user record is various registers.
1. Manual work.
Although the manual work of reliable and going on quite well, but it can never the alternate
of an automated system. The efficiency of manual work can affect 50 e.g. by the tiredness
and boredom of the staff members. The annual system is a bit slower because it consists of
searching a user record various register.
2. Maintenance of various Registers and Redundancy
In the existing system many registers are maintained to store the record of registered
members and information about issuing or returning a book. Registers are also maintained to
stored information about each book. During his storage of information, it often happens that
a single piece of information is repeatedly recorded in more than one place. Thus the same
information is repeatedly recorded in more than one registers which generates redundancy.
Hence, it result in wastage of stationary and also time.
3. Assigning Accession number.
Whenever a new book is to be stored in the library stock, the book is the unique code based
on the accession number. This code helps in searching the book present in the library stock.
10. Redundancy. Data redundancy means that some data are stored twice, Or that some data can be derived from other data currently redundancy is one of the major issues in the system.Some kind of information is captured and/or stored again and again and on multiple places. On the other hand an advantage is that errors can be detected, And that when a data set with some redundancy is damaged, it may be possible to more or less reconstruct the original.
CH
APT
PRO
Chapter No.
Proposed System
1. PROPOSED SYSTEM AND ITS ADVANTAGES
As the system is computerized system so we want to design such a system, which fulfills the
requirements of the departments if ICIT.
The department if ICIT needs a powerful computerized system, which enables the management
to get free from manual system.
■ 1-Time Saving.
■ 2-Economical Benefits.
■ 3-Security Facility.
■ 4-Searching Facility.
■ 5-Rollback Facility.
Searching is very quick in the proposed system, which is a tuff job in the one wants to recall the
old data about any student one must go on.
Searching the registers one by one, and after a hard work he perhaps is able to found that record
or not. Not this sense that record may be present in those register or not.
1.5. Rollback Facility.
It the newly proposed system the facility to rollback whole data is provided. If we want to
rollback the complete data of the book stock entry, students and teachers records we can do it
easily.
1.6. (^) Editing Facility.
In the proposed system, the editing is an easy job to do if there is any fault in the entry system of
the record we can alter it or change it easily, but it is so difficult in the manual system.
1.7. Backup Facility.
In the manual system the record of some files can’t be accessed then that data could be worn and
in the manual system it is not revised able but our newly proposed system provide this facility to
revise that error and make it possible to get backup.
This is whole about the system’s features and we read that our newly proposed system nearly
accomplish those necessities of management which the organization’s leader want.
1.8. Publisher Entry Section.
This Section has the responsibility of keeping the record of all the New Publishers. Each New
Publisher is assigning a unique/Specific Name called Publish Name for its identification. Every
Book will have its own publisher. The information about a Publisher such as Publish ID, Publish
Name is stored in this section with a specific ID called Publisher ID. Here we have also a facility
of updating, the existing record of the Publisher in this section.
1.9. (^) Book Entry And Search Section:
This Section has the responsibility of keeping the record of all the books and managing all new
books is assigning a unique number called Accession number for its identification. A book may
have two or more copies, in which case their titles and ISBN will be the same but their
Accession Number will be different. All the information about a book, such as title author name,
ISBN, Publication year etc are stored in a file are called Accession register. In the present
system, catalogues are used to search a specific book and its location in the library. The
catalogues system on the basis of Devi Decimal Code (DDC) system. Therefore, the stock entry
section assign a unique DDC to each book, which later facilitates the searching of book.
The main task of this section will provide a Record of book that we should enter to the system
through searching of Book Record we will be able to complete detail of the Book easily. Book
Record can be searched through Book id, book name, Book Title, Author Name, (Either first
name or last name are matching character). After searching the book record we will be able to
find a book Storage place also we can judge easily that a book is existing in library storage or
issued to someone. In case of lost of book we can easily know about a book record that will be
not available at library store.
1.10. Program Entry.
This Section has the responsibility of keeping the record of all the New Programs and Existing
program of the concerned Departments. Each New Program is assigning a unique/Specific Name
called Program Name for its identification. The information about a Program such as Program
ID, Program Name is stored in this section with a specific ID called Program ID. Here we have
also a facility of updating, the existing record of the Program in this section.
1.11. Student and Staff Section.
1.11.1. Student Entry And Search: This Section has the responsibility of keeping the record of all the New Students and Existing Student of the concerned Departments. Each New Student is assigning a unique/Specific Number called Student Number for its identification. All the information about a Student such as Student ID, Student Name with his active mobile Number and the permanent address of the student is stored in this section. Here we have also a facility of updating, the existing record of the students in this section.
The main task of this section will provide a data of student that we should enter to the
system through searching of student data we will be able to complete detail of the
