Design And Implementation Of A Computerized Warehouse Management System

Introduction

This chapter gives an overview about the aim, objectives, background and operation environment of the system.

1.1 Background of the Study

Library Management System is an application which refers to library systems which are generally small or medium in size. Itis used by librarian to manage the library using a computerized system where he/she can record various transactions like issue of books, return of books, addition of new books, addition of new students etc. Books and student maintenance Modules are also included in this system which would keep track of the students using the library and also a detailed description about the books a library contains. With this computerized system there will be no loss of book record or member record which generally happens when a non computerized system is used. In addition, report module is also included in Library Management System. If user’s position is admin, the user is able to generate different kinds of reports like lists of students registered, list of books, issue and return reports. All these modules are able to help librarian to manage the library with more convenience and in a more efficient way as compared to library systems which are not computerized.

1.2 Statement of the Problems

The problems found in the Library during Library operation was so much that there were cases where books got missing, if it is not stolen by the student it may be stolen by the staff, part of some books were turn, manual issuing of books and cards, Unidentification of Books in its shelf, time required to record as well as presenting an Information and also the cost of purchasing books, News paper and Journals and Magazines, uneasy returning of books to the library.

Lack of effectiveness in their methods of record keeping, further compounds the problem.

1.3 Objective of the Study

The project aims and objectives that will be achieved after completion of this project are discussed in this subchapter.

The aims and objectives are as follows:

To resolve book issue

To Request column for librarian for providing new books

To create A separate column for digital library

To provide Student login page where student can find books issued by him/her and date of return.

To provide A search column to search availability of books

1.6 Significance of the Study

The significance of this study was to help and give a benefit to the concerned group below.

This study will be beneficial to the following:

Students and Staff:

Through computerized library system, they can easily find the books that they are looking for without going through the traditional way of searching a library material. Convenience is more visible for it is not time-consuming, resulting to a number of accomplished works.

Librarian:

The computerized library system would improve the monitoring capacities of those who maintain the library. It would be easier to determine whether a particular book is on-shelf or not. In addition, they can easily identify when will the borrowed material be returned and if a borrower has failed to return the book on its due date. Furthermore, the librarian would be much guided when it comes to recognizing new inventory books, letting them arrange it promptly and accordingly.

1.7 Limitation of the Study

Unavailability of academic materials.

Transport problem

Lack of financial support

Lack of Time

Unavailability of programming software such as Visual Basic 6, and .Net.

1.9 Scope of the Study

This research work will concentrate on Master entry (i.e. Department, course, student registration, etc…), Users (Registration and login details), Serial control, Transaction, records, tools and about menu which includes handling of some queries like; updating library record, deleting library record and searching for student and staff information via Rank, Department or ID as the case may be. It is a case study of Spring Light Technology Library, Akwa Ibom State.

1.8 Assumption of the Study

During the process of data collection, information relating to Library Management System was obtained from IBOM E – LIBRARY. The information was collected from the admin staff during the course of my industrial attachment. Hence, it is assumed that all the data collected are correct and contains no false information.

1.8 Definition of Terms

Library:

It is a department in an organization that deals with keeping tracks of book issued, returned and added to library.

Management:

It is the co-ordination of all the resources of an organization through the process of planning, organization, directing and controlling

System:

Physical component of a computer that is used to perform certain task.

Data:

Numbers, Text or image which is in the form suitable for storage in or processing by a computer, or an incomplete
Information.

Information:

A meaning full material derived from computer data by organizing it and Interpreting it in a specified way.

Input:

Data entered into a computer for storage or processing.

Output:

Information produced from a computer after processing.

Information System:

A set of interrelated components that collect (or retrieve), process, store and distribute information to support decision making and control in an organization.

Library Management System:

A library management system, also known as an automated library system is software that has been developed to handle basic housekeeping functions of a library.

Computer:

Computer is an electronic device that accepts data as Input, processes data and gives out information as output to the user.

Sofware:

Software is set of related programs that are designed by the manufacturer to control the hardware and to enable the computer perform a given task.

Hardware:

Hardware is a physical part of a computer that can be touched, seen, feel which are been control by the software to perform a given task.

Database:

Database is the collection of related data in an organized form.

Programming:

Programming is a set of coded instruction which the computers understands and obey.

Technology:

Technology is the branch of knowledge that deals with the creation and use technical and their interrelation with life, society and the environment, drawing upon such as industrial art, engineering, applied science and pure science.

Algorithm:

A set of logic rules determined during the design phase of a data matching application. The ‘blueprint’ used to turn logic rules into computer instructions that detail what step to perform in what order.

Application:

The final combination of software and hardware which performs the data matching.

Data Matching Database:

A structured collection of records or data that is stored in a computer system.

Data Cleansing:

The proactive identification and correction of data quality issues which affect an agency’s ability to effectively use its data.

Data Integrity:

The quality of correctness, completeness and complain with the intention of the creators of the data i.e ‘fit for purpose’

Enrollment:

The process of an individual to enroll aith an agency. Involves the initial collection of identifying details.

Summary, Conclusion and Recommendations

5.1 Summary

In summary, this Academic Work project has done a great deal of giving a broad knowledge of what Library database management system is all about. It went as far as highlighting the works of Library database system.

5.2 Conclusion

From this Academic Work, I have been able to show the application of database management system(Library Management System) and how it can be used, it has achieve the full aim of letting the public know what computer system is all about.

5.3 Recommendation

I hereby recommend this Academic work to be used by staff and management of ……. and indeed any other Institution with similar structure and organizational framework for the following reasons:

The academic work has been able to solve the problem related to easy access of Library information.

It has helped to issued out cards, giving report and knowing the number of books stored and borrowed in the library.