Design And Implementation Of Library Stock Management

Description

ABSTRACT

Library stock system is a fast growing company since the ancient methods of maintaining it are no longer dynamic and efficient, for expeditious retrieval and dissemination of information and better services for the client, application of modern techniques have become absolutely indispensable. This project focuses on developing software for a web based library stock management system which can enable the librarian to record all the books stocked in the library and also assign. The objectives of this is to build a web database for storing books stocked in the library, also to develop a web base system which will help to manage and record books borrowed and returned in the library, to assign every book unique identification number. The method used in developing this software is the waterfall model. The researcher used this methodology in the design of the software and it was implemented using sublime text on a Microsoft windows operating system using basic HTML codes, PHP, CSS and MySQL language for the relational database. The result gotten from this project was a web based library stock management system.

TABLE OF CONTENTS

COVER PAGE

TITLE PAGE

APPROVAL PAGE

DEDICATION

ACKNOWELDGEMENT

ABSTRACT

CHAPTER ONE

• INTRODUCTION
• BACKGROUND OF THE PROJECT
• OBJECTIVE OF THE STUDY
• SIGNIFICANCE OF THE STUDY
• SCOPE OF THE STUDY
• LIMITATION OF THE STUDY
• PROJECT ORGANISATION

CHAPTER TWO

LITERATURE REVIEW

• THEORETICAL BACKGROUND
• REVIEW OF RELATED LITERATURE
• SUMMARY

CHAPTER THREE

SYSTEM ANALYSIS AND DESIGN

• METHODOLOGY
• ANALYSIS OF THE EXISTING SYSTEM
• ANALYSIS OF THE PROPOSED SYSTEM
• DESIGN OF THE PROPOSED SYSTEM

CHAPTER FOUR

• SYSTEM IMPLEMENTATION
• CHOICE OF DEVELOPMENT ENVIRONMENT
• SOFTWARE TESTING
• DOCUMENTATION

CHAPTER FIVE

• SUMMARY
• CONCLUSION
• RECOMMENDATION
• REFERENCES

CHAPTER ONE

• INTRODUCTION

Library is a fast growing company. The ancient methods of maintaining it are no longer dynamic and efficient. For expeditious retrieval and dissemination of information and better service for the client, application of modern techniques has become absolutely indispensable.

A properly computerized library will help its users with quick and prompt services. Library automation refers to mechanization of library housekeeping operations predominantly by computerization.

The most commonly known housekeeping operations are acquisition control, serials control, cataloguing, and classification and circulation control. Library stock managements is an enterprise  resource  planning systems for a library, used to tracks items owned, order made, bills paid etc.

• BACKGROUND OF THE STUDY

With the improvement of people’s level of knowledge, the library has become an indispensable part of daily life. But the library storage and the business volume are huge, the traditional accounts’ management is merely not feasible. At the time, library management system comes into being and becomes an important part of information construction gradually. In order to develop, build and adapt to the modern information society, establishing a management information system becomes the main trend, and also we can’t avoid the problem. The implementation of electronic book management can help human resource officials free themselves from the heavy deskwork to complete some more important work. Library management system is to reduce and solve the cumbersome manual management, so that the library can rise to a perfect electronic management.

The history of the library management system could date back to the late 1960s. At that time, computer technology had entered the practical stage. Meanwhile in most large-scale libraries, it’s very time-consuming and easy to make mistakes to find books or statistical information manually. In order to solve this situation, the first generation of book lending management system came into being. But due to the immature technical conditions and the constraints of demands, the user was very small. There was no doubt that its appearance showed a bright future for the management of book lending, that is, with the computer’s high speed and automation to replace the huge amount of manual work and with the computer’s high accuracy to avoid manual mistakes and errors. The second generation of the library management system appeared in the late 1970s. On account of the rapid development of computer technology, whether the popularity of computers, or the developments of computer system tools and database technology, it provided the possibility for the phasic development of library lending management system. But it failed to systematically consider the needs and concepts of book borrowing.

The revolutionary change in the library management system occurred in the late 1990s. With the information explosion and the arrival of the era of knowledge-driven economy, individuals, units and social had a higher demand on library management system. In the meantime, due to the pullulating of database technology, customer/server technology, especially Internet/Intranet technology, the third generation of books borrowing management system had become inevitable. The third generation of library management system was characterized by the angle of book borrowing management, it dealt with almost all data related to the book lending with a centralized database. The friendly user interface, powerful report generation tools, analysis tools and information sharing allowed managers to get rid of heavy daily work and focus on planning and policies of book lending from a strategic perspective.

At first, the library management system software is mainly written in assembly language. With the birth of C language and its advantages and powerful features (from [1] ), library management system based on the C language produced. The author [2] pointed out: at this stage, digital library management system is a prerequisite for students to create a better reading environment. The core is how to make it with the perfect combination of the Internet, and truly achieve timeliness and accuracy. Authors in [3] and [4] have analyzed the status of the digital construction of university libraries, and tried to put forward their own construction plans for the digital construction of local university libraries. The authors in [5] pointed out that many miniature libraries had begun to fully understand the importance of computer technology in library management, and began to use computer technology to achieve the practical application of library books. However, miniature libraries usually have fewer funds, lack of professional management and have other issues. There are many problems of using such a large system, so small and medium-sized libraries do not have such conditions to configure large-scale systems. In view of this problem, the development of miniature library management system has become an urgent affair. Some authors in [6] mentioned it respectively specifics the development process of the library management from the demand analysis and summary design to the detailed design system. And it minutely introduces the interaction between the various modules of library management system. Through the development of the system, it solves some contradictions in the management of library data and achieves the efficient management of data. Basing on Visual Basic 6.0 and SQL Server 2000 system developing to achieve a new library management system is imperative. The author in [7] used mainly B/S structure and ASP. NET + SQL Server technology as a web development tool to develop the public book system. Firstly, it makes a system analysis and divided the main function of the system. Then, it provides the key technology of the system design and the database design of the system. In [8] an implementation procedure of library management system database design and system function was introduced. It used C/S and B/S combined technology to achieve the book and journals computer network management and Web query function. With the increasing of volume, the difficulty of books recorder and inquiry also increased. Then usual methods cannot meet the requirements. In [9] , the author pointed out that the development of library information system mainly includes two aspects: using database technology and developing application systems. In [10] , authors elaborated some thoughts about the problems existed in the processing of library digitization. In [11] , a sub-cycle management library 2.0 model was proposed. System objectives are: for the administrator, it provides all the details of the borrower, as well as the details of the library inventory; for students or ordinary users, it has two functions includes borrowing and returning books; the administrator can also record new books, delete old books and so on. Visitors can also enter the system without a registering user, but there are certain functional limitations.

•     STATEMENT OF THE PROBLEM

Some of the problems encountered in the manual library stock management system in institutions include:

1. Lack of comprehensive database for book stocked in the library,
2. Poor determination books due and overdue,
3. Lack of verifiable borrowed material from the borrowers (student and staff)
4. Stress to the library attendance to attended the users
   • AIM AND OBJECTIVES

The aim of this project is to design and implement a library stock management system.

The objectives include:

1. To build a web database for storing books using IDs assigned to each book,
2. To develop a web base which helps to manage and record library stocks
3. To give account of borrowed and un borrowed books ,
4. Reduction of verbal words between the library users and the attendance
   • SIGNIFICANCE OF STUDY

With growth of information technology, the study offers numerous values in library stock management system;

1. Library users get quality services,
2. It will be easier to borrow books,
3. It will provide efficient, effective and timely services,
4. Record keeping will be more efficient.
5. .5 LIMITATION OF THE STUDY

If software is corrupted, whole data will be collapsed.

1.6                                                         SCOPE OF THE STUDY

The library management system runs on the DOS system, According to the characteristics of the system, we construct the development model and then build structural analysis, system function modules and system flow chart through the demand analysis of the system. Through the analysis of each function module, the definition and attributes of the data and the realization of each function are determined. In the paper, the design of the library management system includes the user module, the administrator module and the module of tourists and also achieves the usual function including borrowing books, returning books and books management.

1.7                                                         PROJECT ORGANISATION

The work is organized as follows: chapter one discuses the introductory part of the work,   chapter two presents the literature review of the study,  chapter three describes the methods applied,  chapter four discusses the results of the work, chapter five summarizes the research outcomes and the recommendations.