DBMS of Saint Michael College of Caraga

Chapter I
Introduction

The world of Information Technology transformed and made the life of human beings easier through the innovation of different machines and software applications. Faster and reliable sources have been offered by search engines which are all over the web. But even though this is the case, many schools and universities are still requiring their students to use library materials in their researches and school works. From the statement of purpose, the compute’rized library system: meeting information needs of the people of Saint Michael College of Caraga, Nasipit, Agusan del Norte.

Our proposed system, the Saint Michael College of Caraga Library Management System, is a system wherein there is no need of manual library transactions. This will carry out different processes such as searching books, keep records of the books, borrowing of books and return of books. Hence, at present, Saint Michael College of Caraga is maintaining the School Library in a manual basis.

Handling bulky records in a manual method is very difficult.

Library is regarded as the brain of any institute; many institutes understand the importance of the library to the growth of the institute and their esteem users (students).

Library Management System of Saint Michael College of Caraga supports the general requirement of the library like acquisition, cataloguing, circulation that offers many flexible and convenient features, allowing librarians and library users to maximize time and efficiency. Library System gives the all detailed information about students, staff and books. It will track on the how many books available in library and books issued to the students. It shows popular book among the students. It will provide book lost in library. It keeps the record of the suppliers and book binders. It generates MIS reports for management. Our software is customizable for any library requirement.

In this chapter we take opportunity to consider changes in the library services, not in terms of minor, short term change in equilibrium of the sort just noted above, but in longer term. There has been continuing concern about the future of the libraries. Given the extent to which the provision used and the libraries are influenced by the social environment, and given possibilities by the use of new information technology; it would be unreasonable to expect libraries to remain static. But if not, what would be the nature of the change? The issue is not whether there is a change but what will be the change. If we are to make a claim to understand the nature of library services, the surely we ought to have notions, some forecasts, about how library system might change.

Purpose and Description

In setting up a library, one aspect that should be considered, what are the resources the library has and what are the ways to provide a better service to the students? Well, one of the easiest ways is having a system to organize all the transactions in the library. A library system is software that will handle basic and systematic organization of function in the library. The system would provide basic set of features to add/update student’s information, add/update books information, search for books and manage check-in/check-out processes. In this application we can maintain the records of students and books and enable to determine how many books are issued and likewise determine the available books in the library.

The proposed library system will greatly improve the efficiency of the school library. This study has the following hypothesis: The profiles of the respondents taken are their names, Student ID Number, Year and Course, and Title and Author of the Book Borrowed. The manual system is very time consuming, inconvenient when it comes to recording, organizing and retrieving borrower’s record in the log book. There are few solutions but many a times, we “making them works” by finding “ways to work around” system inadequacies.

Moreover we have limited staff resources, these “work around” waste time, effort, and skills that should be spent on user services. solutions do not keep up with the technological changes and hence prove to be time wasters. Library Management system is a small footprint software suitable for personal /individual Libraries. You can store the information about the books and other material and control the movement of the same.

Silent Features

• Control the movement of books and other material and avoid losing the same. • Search if you have a specific book in your collection based on t he title, author etc. • Print the spine labels for the book.

• Find what a specific person has borrowed from you.

Objectives

The main objective of the application is to automate the existing system of manually maintain the records of the Book Issue, Book Return from the student, Stock Maintenance, and Book Search to be computerized. And to develop a database which stores user details and book details, give reliable search facility for the user, create an easy to understand user friendly environment. So the Book Issue, Return, Searching will be faster. This application can be used by any Library to automate the process of manually maintaining the records related to the subject of maintaining the stock and Book Issues. The general objective of this study is to design and develop a library system that will serve as a proposal to help librarians save time with the automation of its daily operation.

Specific Objectives:

To computerize records keeping of books;
To allow librarians to retrieve complete information of the book and its borrowers.

To check the availability of the books and penalties.
To search, issue and return of books.
It can only be utilized by the librarian

Scope and Limitation

The study only focuses on the Information Technology Library Management System of Saint Michael College of Caraga. Without computers, as some libraries are, all of them are dependent on paper work. When compared to computerized systems, data backup and data retrieval systems are inefficient and labor intensive. Users of a paper based system become almost wholly reliant on the librarians, for all levels of service, whether they are enquiries about existing books, inter-library loans, or the availability of books. There is additionally no real involvement of a user in the entire process. The transactions that the system accommodates are the attendance of every student that enter the library, book registration and deletion, updating book information and searching thesis references, Borrowing of books, and keeping the record of transaction.

Review of Related Literature

This chapter contains the relevant outline of literatures related to the study of Library system. This study composed of programming languages, Database and Graphical User Interface (GUI) that is used in the system. This system would be used by members who may be students or professors of that University to check the availability of the books and borrow the books using automated device, and by the librarian to update the databases. The purpose of this document is to analyze and elaborate on the high-level needs and features of the Library Management System. It focuses on the capabilities and facilities provided by a Library. The details of what all are the needs of the Library Management System and if it fulfils these needs are detailed in the use-case and supplementary specifications.

Automated book monitoring system helps to reduce the effect of entering the wrong quantity and the amount of staff time devoted to repetitive activities.

Related Studies

According to ACRL (1994) suggested that institution should be prepared to utilized new technologies for accessing information as they are developed. This is why operating the library operations is quite a welcome idea.

According to Jeff Kaplan (05/08/2007 A new generation of automated network management software and services is helping in-house staff address this challenge. These let network professionals establish regular patch-management procedures to safeguard against escalating security threats; and create system monitoring routines to identify load imbalances, which could cause service disruptions or performance problems. They also discover, inventory and track assets to make sure that hardware and software licenses are up-to-date and that problems can be resolved faster.

According to Voustin Sweere (Aug.2001) Nowadays every book keeping system used in practice is automated. Most book keeping software an integrated information system are based on database. In this paper, we develop a conceptual book keeping model which is not based on manual techniques, but which is applicable in database environment.

Technical Background

In this chapter, it provides an overview of all the overall system design, features and functionalities. The system is design to implement a computerize library management system in Saint Michael College of Caraga. This system consists of one user, the administrator. The administrator can access the system by having first the login security which they have to input his/her user name and password. Once the inputted username and password did not match, the required/registered information it displays “Invalid Username and Password”. If the username and password match the registered information, the next form will display depending on the role of the administrator.