1.1 Background of the Problem
STI is the second largest IT-based educational institution in Asia and has branches all over the Philippines. It has a branch in Malolos and is located at McArthur Highway Veritas compound, Dakila, Malolos City, Bulacan. There are more than two hundred students and around sixteen (16) personnel including part-time and full-time faculty members. All students and faculty members are allowed to borrow books. The STI College Malolos Library has only one Librarian. There are 5,586 books with a wide array of topics/subjects. It houses two computer units as extension to research for users whose needs are not supplied within the location.
As for the school librarian, the librarian has difficulties in computing charges generating reports, monitoring overdue and managing database.
The proponents aim for the improvement and efficiency of the school’s library transactions.
1.2 Overview of the Current State of the Technology
`Library System is an enterprise resource planning system for a library, used to track items owned, bills paid from patrons who have been lost the book or overdue book and patrons who have borrowed.
1.3 Project Rationale
The library of STI College Malolos will benefit from the proposed computerized library system with Barcode Technology. It will reduce time and effort for both librarian and students. Students
The Students of STI College Malolos will benefits from this system because they can easily borrow or return from the library. They don’t need to search the book by borrowing through index card. Librarian
The librarian will also benefits a lot from this system because the
computerized library system with barcode technology would help her lessen her work from maintaining the books from their availability since its already computerized. The work of the librarian would be easier and faster. It will help her to easily monitor the transaction of the books. Proponents
The proponents will also benefits from this system because the proponents can apply their knowledge that they have learned from school. The system is a very big advantage to them because it will develop their skills in terms of programming.
2.0 PROJECT DESCRIPTION
2.1 Problem Statement
Since STI College Malolos is using manual transaction there are possibility that data might get misplaced during manual transactions and time consuming. Too much paper work, since everything and every detail is written down manually in paper.
2.2 Proposed Research Project
2.2.1 General Objectives
The main objective of this study is to come up with Computerized Library System with Barcode Technology for STI College Malolos.. The proponents would like to automate STI College Malolos process using Barcode Technology to reduce tie and effort for both librarian and students.
2.2.2 Specific Objectives
To create a module that will compute penalties for delinquent borrowers. -A function that will generate a minimum amount of penalty for the delinquent of the library. The penalty will be based on the librarian. To create a module that will generate reports.
-System will generate standardized reports such as list of borrows, list of new books, list of damaged books, list of delinquent borrowers and other periodically and start to end date of report and other options can be included. This system will held the librarian create reports that are required by school. To create a security and model in audit trail.
-The proposed system will improved the record keeping process of their current system by having security measures and database that will accommodate all the transactions inside the library. Each user will be given a certain level of security to ensure the security of the database. The module has a log in system that will require username nad password before system can be used. Level of Accesion will be implemented to protect confidential records that other users should not see or use. An audit trail will be used to track transactions that require the modifying or updating of sensitive and confidential records. To create a transaction module for borrowing and returning book(s). -Having a computerized system in borrowing, returning and searching of books. It is easier and more convenient for the user to find a certain book by title, by subject author. The time required in searching and processing these trasactions in the will require the modifying or updating or updating of sensitive and confidential record.
2.2.3 Scope and Limitations
Proposed system will cover the following:
Books File Maintenance
-The system can store, retrieve, modify and deleted file will moved to archive of records. Return and Borrowing Transaction
-The system is automatically set the day of return and borrowing. Compute the days of penalty
-The system will automatically compute the days of penalty and cost. Reports
– Back-up and Restore
– Audit Trail
– User Setting
– Change Password
– Time and Date Setting
The system will not cover the following:
-The system will not cover the reservation of the books.
-The system will not include inventory of other STI College Malolos Library assets such as
6 Parts of Spiral Model:
-We conduct an interview to gather information that we need to this proposed project. We provide questionnaires and make researches about the STI College
-We distributed task for each member and created questionnaires for the interview.
-We identify the errors and bugs in our system. We will analyze each and every error occurred during testing.
-We design and constructed the system using Microsoft Visual Basic 6.0, Adobe Photoshop 5.0 and MySQL.
Construction and Release
-The system will be tested in STI College Malolos to check if the system reached their satisfaction. We will also teach them how to manipulate this system.
-Asking for feedback from customer is important in making a system. In this part of Spiral model, we ask for feedback to our customer for us to know what the rating of our system is.
3.0 PROJECT MANAGEMENT
•JULY 1 – 10
– Searching for Company
•JULY 10 – 11
– Conduct Interview
•JULY 12 – AUGUST 30
– Conduct Research
•JULY 15 – AUGUST 30
•JULY 22 – SEPTEMBER 11
•AUGUST 1 – SEPTEMBER 22
The proposed Computerized Library System with Barcode Technology for STI College Malolos requires hardware requirements as well. Since the school has a computer laboratory, STI College Malolos already meets all the requirements for a desktop, at least Intel Pentium 4 Processor with at least 2,4Ghz, at least 512mb RAM, and 80gb Hard Disk Drive and Barcode Technology.
The proposed system will run in windows XP SP2 and SP3 with MySQL for data storage program of the system.
4.2 Resource Persons
Ms. Claricel V. Mejia
STI College Malolos
Mr. Christopher Rae Perez
School IT Head
STI College Malolos
Mr. Samson Eugenio
School’s Academic Head
STI College Malolos
4.3 Personal Technique Vitae
Maelynne Joy A. Estander
San Pablo, Malolos City
Mark Allan D. Francisco
Grand Royale, Malolos City
Emil Paolo M. Tamondong
Lugam, Malolos City