Automated Library Stock Management System:- Stephen Uchechukwu S.

ABSTRACT

Automated library stock management system is software that allows you to search for books, manage books and monitor borrowed books, pay fines and fees all in one location. It helps the librarian manage books and books borrowed by members while also automating the bulk of library functions. It improves efficiency, lowers library maintenance expenses, and saves both the user and the librarian time and effort. The goal of this project is to provide a system for handling all information about the Librarian, the students and catalogs such as books, magazines, and newspapers. I was motivated to embark on this research because of the current manual library operations, services and transactions, difficulty in locating books in the library, the internet usage duration is restricted and the available system is not known by most of the students. The system was achieved by developing a platform for an automated application for library stock management system, build a database structure that holds the records of the staff and students including the visitors, create a module for user login, design a platform that add user’s information, design a platform that add books, design a platform that displays and view user’s information. The library management system will improve services for both users e.g., students and library management system will enhance services for both users - e.g., students and staff- e.g., librarians such as shortening the time it takes to find books and increasing the accuracy and timeliness of record generation, among other things. This research was realized through the adoption of primary and secondary sources of data collection which includes interview, observation, questionnaire, the internet, journals and the adoption of prototype methodology. The system is implemented by using PHP, HTML, CSS and JavaScript in the development of the web application and MYSQL as the database.

TABLE OF CONTENTS

Title Page                                                                                                                    i

Certification                                                                                                                ii

Dedication                                                                                                                 iii

Acknowledgments                                                                                                     iv

Table of Contents                                                                                                       v

Abstract                                                                                                                      viii                                                    

CHAPTER 1             INTRODUCTION

1.1       Introduction                                                                                                    1

1.2       Statement of the Problem                                                                               3

1.3       Aim Objectives of the Study                                                                          4

1.4       Significance of the Study                                                                               4

1.5       Scope of the Study                                                                                         4

1.6       Definition of terms                                                                                         4

 CHAPTER 2                        LITERATURE REVIEW

2.0       Overview of Related Literature                                                                      6

2.1       Introduction                                                                                                    6

2.2       Related Literature Review                                                                              6

2.3       Computer-Based Information System (CBIS)                                               8

2.3.1    Types of Information System                                                                                     9

2.3.1.1 Transaction Processing System                                                                       9

CHAPTER 3             RESEARCH METHODOLOGY AND SYSTEM ANALYSIS

3.1       Research methodology                                                                                  11

3.2       Analysis of the Existing system                                                                      13

3.2.1    Weakness of the Existing System                                                                   14

3.3       Methods of Data collection                                                                            14

3.3.1    Interview                                                                                                         15

3.3.2    Observation                                                                                                     15

3.3.3    Questionnaire                                                                                                  15

3.3.4    Internet or Surfing the Net                                                                             16

3.4       Data flow Diagram of the proposed system                                                   16

3.5       Use case Diagram of the Proposed system                                                     17

3.6       Flowchart of the proposed system                                                                  18

3.7       Class Diagram of the Proposed system                                                          19

3.8       Activity Diagram of the Proposed system                                                      20

3.9       Sequence Diagram of the Proposed System                                                   21

3.10     Analysis of the proposed system                                                                    21

3.10.1  Input Analysis of the proposed system                                                          22

3.10.2  Output Analysis of the proposed system                                                        22

3.10.3  Data analysis of the proposed system                                                             22

CHAPTER 4             SYSTEM DESIGN AND IMPLEMENTATION

4.1       System Specification                                                                                      24

4.2       Overview of Software Design                                                                                    25

4.2.1    Model Diagram of the Proposed System                                                        26

4.2.2    Architecture of the Proposed System                                                             27

4.2.3    Operational Mechanism for the Proposed System                                          28

4.2.4    Main Menu Design                                                                                         28

4.2.5    Input Form Design                                                                                          29

4.2.6    Output Form Design                                                                                       30

4.2.7    Database Design                                                                                             30

4.3       System Implementation                                                                                  32

4.3.1    Main Menu Implementation                                                                           32

4.3.2    Input form implementation                                                                             33

4.3.3    Output Form Implementation                                                                         36

4.3.4    Database Implementation                                                                               37

CHAPTER 5             SUMMARY, CONCLUSION AND RECOMMENDATION

5.1.      Summary                                                                                                         38

5.2       Conclusion                                                                                                      38

5.3       Recommendations                                                                                          39

REFERENCES                                                                                                        40

APPENDIX A

Program Source Code                                                                                                 42

APPENDIX B

Program Output                                                                                                          46