qwertyuiopasdfghjklzxcvbnmqwertyui

opasdfghjklzxcvbnmqwertyuiopasdfgh
jklzxcvbnmqwertyuiopasdfghjklzxcvb
nmqwertyuiopasdfghjklzxcvbnmqwer
Library management system
tyuiopasdfghjklzxcvbnmqwertyuiopas
CSE-301

dfghjklzxcvbnmqwertyuiopasdfghjklzx
9/30/2010

Ankush Sharma

cvbnmqwertyuiopasdfghjklzxcvbnmq
wertyuiopasdfghjklzxcvbnmqwertyuio
pasdfghjklzxcvbnmqwertyuiopasdfghj
klzxcvbnmqwertyuiopasdfghjklzxcvbn
mqwertyuiopasdfghjklzxcvbnmqwerty
uiopasdfghjklzxcvbnmqwertyuiopasdf
ghjklzxcvbnmqwertyuiopasdfghjklzxc
vbnmqwertyuiopasdfghjklzxcvbnmrty
uiopasdfghjklzxcvbnmqwertyuiopasdf
ghjklzxcvbnmqwertyuiopasdfghjklzxc
ACKNOWLEDGEMENT

I express my heartiest gratitude to towards my teacher

MISS CHAVI who assigned me the term paper “LIBRARY
MANAGEMENT SYSTEM”. I also thank her for guiding me
and helping me throughout this term paper. She also
supported me in completion of this term paper and gave
me relevant information related to this topic.
 Library management system
Library management system (LMS) is an enterprise resource planning system for a library, used
to track items owned, orders made, bills paid, and patrons who have borrowed.

An LMS usually comprises a relational database, software to interact with that database, and two
graphical user interfaces (one for patrons, one for staff). Most LMS separate software functions
into discrete programs called modules, each of them integrated with a unified interface.

INTRODUCTION:
A library database needs to store information pertaining to its users its workers, the physical
locations of its branches, and the media stored in those locations. We have decided to limit the
media to two types: books and videos.

The library must keep track of the status of each media item: its location, status, descriptive
attributes, and cost for losses and latereturns. Books will be identified by their ISBN, and movies
by their title and year. In order to allow multiple copies of the same book or video, each media
item will have a unique ID number.

Customers will provide their name, address, phone number, and date of birth when signing up
for a library card. They will then be assigned a unique user name and ID number, plus a
temporary password that will have to be changed. Checkout operations will require a library
card, as will requests to put media on hold. Each library card will have its own fines, but active
fines on any of a customer's cards will prevent the customer from using the library's services.

The library will have branches in various physical locations. Branches will be identified by
name, and each branch will have an address and a phone number associated with it.
Additionally, a library branch will store media and have employees.

Employees will work at a specific branch of the library. They receive a paycheck, but they can
also have library cards; therefore, the same information that is collected about customers should
be collected about employees.
Functions for MEMBER:

● Log in

● Search for media based on one or more of the following criteria:

○ type (book, video, or both)

○ title

○ author or director

○ year

● Put media on hold

● Pay fines for lost or late items

● Update personal information:

○ Phone numbers

○ Addresses

○ Passwords
Functions for LIBRARIAN are the same as the functions for customers plus
the following:

● Add customers

● Add library cards and assign them to customers

● Check out media

● Manage and transfer media that is currently on hold

● Handle returns

● Modify customers' fines

● Add media to the database

● Remove media from the database

● Receive payments from customers and update the customers'

Fines.
E-R DIAGRAM OF LIBRARY MANAGEMENT SYSTEM

LIBRARY

CONTAINS
NUMBER
OF BOOKS
BOOK_NAME

AUTHOR

BOOKS SUBJECT_CODE

BOOK_CODE

PRICE

ISSUE
 ADDRESS
STATUS

MEMBER DATE_ISSUE

AMOUNT

TYPE ID
NAME

RETURN ISSUE

STATUS OF RETURN STATUS OF ISSUE

ID EXPIRE_DATE
EXPIRE_DATE ID

BOOK_CODE
W DATE OF ISSUE
DATE_ISSUE

BOOK_CODE
Database is concerned there are only 4 tables

1. Lib_Users

- fields are User_ID, User_Name, no_Of_Books_Issued

2. Book_Detail

- fields are Lib_Book_ID, Lib_Book_Title, Book_Category, Book_Author_Name ,

Book_Status

3.Issue_Details

- fields are Book_Issue_ID, Book_ID, Issued_On,

Issued_To, Returned_On

4. Book_Cat - fields are Cat_ID, Cat_Name

There are two different users who will be using this product:

 Librarian who will be acting as the administrator

 Student of the University who will be accessing the Library online.
 The features that are available to the Librarian are:

 A librarian can issue a book to the student

 Can view The different categories of books available in the Library
 Can view the List of books available in each category
 Can take the book returned from students
 Add books and their information of the books to the database
 Edit the information of the existing books.
 Can check the report of the issued Books.
 Can access all the accounts of the students.

The features available to the Students are:

 Can view The different categories of books available in the Library

 Can view the List of books available in each category
 Can own an account in the library
 Can view the books issued to him
 Can put a request for a new book
 Can view the history of books issued to him previously
 Can search for a particular book

Proposed Database should store, retrieve, update, and manipulate information related to
university which include

 Books availability
 Staff information
 Student details
 My Account
 Calculation of fines
TABLE CREATION AND INSERTION:

TABLE LIBRARY USERS:

-->create table lib_user(user_id int,u_name char(20),u_no_of_book_issued int);

-->insert into lib_user values(10801907,'tavishi',3);

-->insert into lib_user values(1080484,'sheena',3);

-->insert into lib_user values(10800043,'rahul',2);

-->insert into lib_user values(10810760,'arushi',1);

TABLE BOOKS DETAIL:
-->create table books_detail(book_id varchar(20),book_title char(20),book_category
char(20),book_author char(20),book_status int);

-->insert into books_detail values('i 123', 'dbms', 'computer', 'sudarshan', 0);

-->insert into books_detail values('h 548', 'operating system', 'computer', 'gilbert', 1);

-->insert into books_detail values('m 367', 'microprocessor', 'ece','bram', 1);

-->insert into books_detail values('s 109', 'programming in c', 'computer', 'anshuman', 0)

TABLE BOOKS CATEGORY:

-->create table book_cat(cat_id varchar(10) , cat_name char(15));

-->alter table book_cat add primary key(cat_id);

-->insert into book_cat values('c_001', 'eng');

-->insert into book_cat values('c_011', 'history');

-->insert into book_cat values('c_010', 'computer');

-->insert into book_cat values('c_012', 'ece');

select * from book_cat;

QUERIES

 DELETE FROM BOOKs_detail WHERE BOOK_id=’I 123’;

THIS QUERY WILL DELETE THE RECORD OF BOOK_NAME=’dbms’ FROM THE

BOOKs_detail TABLE.

 SELECT BOOK_TITLE, BOOK_AUTHOR, BOOK_STATUS, CAT_NAME

FROM BOOKS_DETAIL

INNER JOIN BOOK_CAT

ON BOOKS_DETAIL.BOOK_CATEGORY=BOOK_CAT.CAT_NAME
TO GET BOOKS AVAILABLE:

SELECT BOOK_TITLE, BOOK_AUTHOR, BOOK_STATUS, CAT_NAME

FROM BOOKS_DETAIL

INNER JOIN BOOK_CAT

ON BOOKS_DETAIL.BOOK_CATEGORY=BOOK_CAT.CAT_NAME

WHERE BOOK_STATUS=1;
REFERENCES:

http://en.wikipedia.org/wiki/Integrated_library_system

http://www.dotnetspider.com/projects/3-Library-Management-System.aspx

http://www.scribd.com/doc/17337071/Srs-Library-Management-System