Structured Query Language

Library Management System

Prashanth Reddy Cemarla

Wilmington University

Library Management System

Abstract

The main theme of my project is to give the complete information about the library. We can enter the record of the new books and retrieve the details of books available in the library. We can issue the books to the student and maintain their records. We can also check how many books are issued and number of books available in the library. In this case study, we can maintain the late fine of the student who returns the issued books after the due date.

Throughout the case study, the focus has been on presenting information and comments in an easy and an intelligible manner. The case study is very useful for those who want to know about library management system.

Introduction

All librarians in the olden days currently operate all its administrations using handwritten forms or slips stored in drover (files). The handwritten information may also cause some clashes in the records such as missing a particular slip or maintaining the records in large librarian. It is also difficult to search a particular record from a bunch of records. So to avoid the problem arises, we need an automated system that keeps a track of all the records and related information.

DRAWBACKS OF CURRENT SYSTEM

* Lack of immediate information retrieval

* Lack of immediate information storage

* Lack of prompt updating

* Lack of storing large information

* Redundancy information

* Fast report generation is not possible

* Tracing a book is different

* No central database can be created, as information is not available in database

PROBLEM STATEMENT

We want to develop library management system a comprehensive library management solution that is suitable for both large and small libraries which has flexible design and which enables library management system to be installed in a range of library organizations ranging from public...