Project Proposal for Library System with Barcode Technology Essay

1.0 INTRODUCTION 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 sensi tive and confidential record. 2.2.3 Scope and Limitations Scope 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 -Book List -Patron List -Transaction List -Returned List ïÆ'ËœArchives -Books -Patrons ïÆ'ËœUtilities – Back-up and Restore – Audit Trail – Setting – User Setting – Change Password – Time and Date Setting Limitations The system will not cover the following: ïÆ'ËœReservation -The system will not cover the reservation of the books. ïÆ'ËœLibrary Budgets -The system will not include inventory of other STI College Malolos Library assets such as oBooks Supplies oTables oChairs oBook Shelf 2.2.4 Methodology Sda 6 Parts of Spiral Model: ïÆ'ËœCustomer Communication -We conduct an interview to gather information that we need to this proposed project. We provide questionnaires and make researches about the STI College Malolos Library. ïÆ'ËœPlanning -We distributed task for each member and created questionnaires for the interview. ïÆ'ËœRisk Analysis -We identify the errors and bugs in our system. We will analyze each and every error occurred during testing. ïÆ'ËœEngineering -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. ïÆ'ËœSystem Evaluation -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 3.1Calendar Activities †¢JULY 1 – 10 – Searching for Company †¢JULY 10 – 11 – Conduct Interview †¢JULY 12 – AUGUST 30 – Conduct Research †¢JULY 15 – AUGUST 30 – Documentation †¢JULY 22 – SEPTEMBER 11 – Coding †¢AUGUST 1 – SEPTEMBER 22 – Testing GANTT CHART 3.2 Resources Hardware 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. Software The proposed system will run in windows XP SP2 and SP3 with MySQL for data storage program of the system. 4.0 APPENDIX 4.1 References http://google.com http://pscode.com http://fb.com/ITEA http://symbianize.com 4.2 Resource Persons Ms. Claricel V. Mejia School Librarian 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 Maelyn_joy18@yahoo..com Mark Allan D. Francisco Grand Royale, Malolos City Mafrancisco14@gmail.com Emil Paolo M. Tamondong Lugam, Malolos City Emilpaolo02@gmail.com