Final Documentation Essay

I. INTRODUCTION 1.1 Background of the Problem 1.2 Overview of the Current Sate of Technology 1.3 Project Rationale II. PROJECT DESCRIPTION 2.1 Problem Statement 2.1.1 Major Statement 2.1.2 Minor Statement 2.2 Proposed Research Project 2.2.1 General Objectives 2.2.2 Specific Objectives 2.2.3 Scope and Limitations 2.2.4 Methodology III. PROJECT MANAGEMENT 3.1 Calendar of Activities 3.1.1 Description of Activities 3.1.2 GANTT Chart of Activities 3.2 Resources 3.2.1 Hardware 3.2.2 Software IV. APPENDIX 4.1 References 4.2 Resource Person/s 4.3 Personal Technical Vitae I. INTRODUCTION 1.1 Background of the Problem Mystical Rose School of Caloocan Inc. was founded by Dr. Marcelina Gregore in 1993. It is located at Ilang-Ilang Street, Almar Subdivision, Camarin, Caloocan City. Since the day the school has been founded they were using the manual library system, which give them hard time to record all the information. The library has this Accession Book where the incoming books and information about the books are recorded. The book records were done manually. Every time a student asks about a kind of book, the librarian finds it hard to locate, because she still needs to go through the list in the Accession Book. Although each book has a unique Accession Number still the librarian couldn’t manage to find it easily because the records of the books in the Accession Book are according to the date received. It takes more time for the librarian to find the record of each book. The librarian also encounter problems in encoding the books’ information because of disorganized records because information about the books is being unmonitored, in a way that some books are not yet listed on the Accession Book. And aside from the Accession Book they are also using the Card Catalog which serves as a guide in locating the books. There are huge amount of books in the library. It has different volumes, editions, authors, class, titles, subjects, years and publishers, and the accession number which set as a unique identity in every book in their library. It is very hard for the librarian to monitor all the books especially when it is encoded manually. 1.2 Overview of the Current State of Technology A student who will use the library must log in first to the attendance book before they enter the library. They have to fill up the information needed like date, student’s name, year & section, time in and out and their signature. If they will borrow books the librarian will record it to the log book. The people who can use the Library are the students, faculty and the Librarian. The Librarian is not required to go to the library every day. The librarian is on call. She has a schedule when to go to the school. When the librarian is not on schedule, the Aid takes the place on the work of the librarian. A student is allowed to borrow how many books they want when they are in the library. The student is also allowed to borrow two books with duration of two days. If the student failed to return the books within two days they are not allowed to borrow books the next time they borrow. And they are not allowed to bring it at home instead they could only borrow when they are inside the library. If the student lost the book, they must replace it with the same book. If the faculty will borrow books they could borrow books as much as they want, there is no limitation. The process of recording the student’s information was done manually by recording on a log book where every student who enters the library needs to fill up the information such as name, section, year level and the date. Same as the book records, the librarian needs to record the book title, author, book number according to its date received and the date to the Accession Book. The record of the books is not arranged properly because it was arranged according to its date received not alphabetically or by subject matter. The system takes a lot of time and endeavor to handle so the librarian must ensure to keep track the records in the library. 1.3 Project Rationale The following will benefit to the proposed System: * Mystical Rose School of Caloocan Inc. The school will be able to experience a Computerized Library System. It can monitor information and the books and records can be settled. The proposed system will record the list of all the books – plus the incoming books, in the library. It will record the students’ information who registered each day. Every time a student wants to borrow a book it will be inputted in the system and record it. It will help the librarian to manage the student’s record as well as the record and information’s of the books. * Student The student will no longer fill up all the information needed in the attendance book every time they enter the library. The transaction of a student will be faster in borrowing and returning of books. * The proponents The Computerized System is also designed for the benefits of the proponents for the compliance of the project in the subject System Analysis and Design and of course it widens their capabilities in creating their target program with the help of planning, researching, designing and developing. They will learn a lot not only in doing the system but also they will experience the real happening in the IT industry. II.PROJECT DESCRIPTION 2.1Problem Statement 2.1.1 Major Statement How will to proponents develop/design a Library System that will help the librarian monitor all the records of the books as well as the student’s information’s? 2.1.2 Minor Statement * How will the proponents create a module that facilitates the security of the system? * How will the proponents create a module that holds the record of books information? * How will the proponents create a module that will hold the record of students and faculties who borrowed books? * How will the proponents create a module that will hold the record of borrowed and returned books? * How will the proponents create a module that will facilitate the availability of the books? 2.2Proposed Research Project 2.2.1 General Objectives * To be able to create a Computerized Library System for Mystical Rose School of Caloocan Inc. 2.2.2 Specific Objectives * To be able to create a module that facilitates the security of the system? * To be able to create a module that holds the record of books information? * To be able to create a module that will hold the record of students and faculties who borrowed books? * To be able to create a module that will hold the record of borrowed and returned books? * To be able to create a module that will facilitate the availability of the books? 2.2.3 Scope and Limitations Scope * Student Information * It can add, edit and delete the important information of a student. Like name, address, guardian and contact number. * Faculty Information * Faculty can also borrow books. * Transaction of Books * Borrowing Books * Returning Book * User Accounts * Librarian * Aid Limitations * The system is not going to use a barcode reader. * It is not capable in computing penalties. 2.2.4 Methodology DATABASE NORMALIZATION * The proponents use this method to organize the fields and tables of the database to minimize data redundancy and dependency. It helps create a much more flexible database design and it can handle better database security. SYSTEM DEVELOPMENT LIFE CYCLE * This serves as guidelines to the proponents because it provides a sequence of activities for the system. In order to create a proposed program, the proponents used this system to identify and to serve as the proponents’ guidelines and patterns in building a Library System for Mystical Rose School of Caloocan Inc. Planning, Analysis, Design, Implementation, Maintenance Planning – The proponents managed different task by dividing the members of the group which each member have their own task to do. Analysis – After concluding the interview, we found out that the company is using a manual system. By creating a Computerized Library System, handling the list of books and students, monitoring, and transactions would be easier and time saving. The proponents gathered required information’s needed for the system. Design – The design of the system is based on the information being gathered by the proponents. For the system is properly designed, the codes are easily generated. III. Project Management 3.1 Calendar of Activities 3.1.1 Description of Activities * Week 1 The proponents passed the proposal letter to the Mystical Rose School of Caloocan Inc., and it was approved by Mr. Mark Gregore, OIC of the school on the other day. * Week 2 The proponents conducted an interview to the librarian and started to make the chapter 1 of the documentation. * Week 3 The proponents started to make the chapter 2 of their documentation. And about 30% of the back-end of the system was made. * Week 4 The proponents finished the design of their system. * Week 5 The proponents finish the chapter 4 of their documentation. The proponents make the 50% of their system. * Week 6 The proponents finished the 75% of their system and make some revision on the documentation. * Week 7 The proponents finished their system as well as the documentation. 3.1.1 GANTT Chart of Activities 3.2Resources 3.2.1 Hardware * Computer Set * Netbook * Laptop 3.2.2 Software * Microsoft Office 2007 * Visual Basic 6.0 SP6 * Windows XP * Windows 7 IV. APPENDIX 4.1 References Google * www.Google.com Sourcecode * www.Sourcecodester.com 4.2 Resource Person/s * Prof. Harold Ramirez Lucero Professor/Dean College of Information Technology Colegio de Sta. Teresa de Avila Foundation Inc. Email: Harold.lucero@yahoo.com Contact No.: 09233033855 * Prof. Carlo Dino Santos Professor College of Information Technology Colegio de Sta. Teresa de Avila Foundation Inc. 4.3 Personal Technical Vitae Trixia Marie C. Albelda No. 69 Marcos Rd, Freedom Park 6, Brgy Batasan Hills, Quezon City Mobile: 09077045988 Email: albeldatrixia@yahoo.com EDUCATIONAL ATTAINMENT: Course Presently Enrolled In: Bachelor of Science in Information Technology Tertiary: Colegio de Sta. Teresa de Avila Foundation Inc. No. 6 Kingfisher St., Corner Skylark St., Zabarte Subd., Novaliches, Q.C. Secondary:Batasan Hills National High School IBP Rd., Batasan Hills, Quezon City 2006-2010 Primary:Merry Mount Preparatory School No. 96 Ilang-ilang St., Payatas A, Quezon City 2000-2006 PERSONAL BACKGROUND: Age:18 Sex:Female Birth Date:May 28, 1994 Height:5’5 Weight:110 lbs. Civil Status:Single Citizenship:Filipino Language:Filipino and English WORK EXPERIENCE On The Job Training Teletech Novaliches June 1 – August 30 SEMINAR ATTENDED: Leadership Training Program CWTS – NSTP Feb. 12 – 13, 2011 CHARACTER REFFERENCE: Mr. Rechor Quijano Business Communication Specialist Teletech Novaliches Mobile: 09328925781 Mr. Harold Lucero, MIT Dean, Information Technology Department Colegio de Sta. Teresa de Avila Mobile: 09233689633 Mrs. Cila B. Madrid Directress, CBM Tutorial Center Nieves St., Batasan Hills, Quezon City Mobile: 09205065922 I hereby certify that the above information is true and correct to the best of my knowledge and belief. ____________________________ Applicant’s Signature Lorraine D. Drilon 3630 Heavenly Drive San Agustin Novaliches, Quezon City Mobile: 09306610648 Email: Lorraine_sus05@yahoo.com EDUCATIONAL ATTAINMENT: Course Presently Enrolled In: Bachelor of Science in Information Technology Tertiary: Colegio de Sta. Teresa de Avila Foundation Inc. No. 6 Kingfisher St., Corner Skylark St., Zabarte Subd., Novaliches, Q.C. Secondary:Novaliches High School TS Cruz Subdivision, San Agustin Novaliches, Quezon City Primary:San Agustin Elementary School Heavenly Drive San Agustin Novaliches, Quezon City 2000-2006 PERSONAL BACKGROUND: Age:19 Sex:Female Birth Date:October 5, 1993 Height:5’3 Weight:108 lbs. Civil Status:Single Citizenship:Filipino Language:Filipino and English WORK EXPERIENCE Service Crew-Cashier Jollibee SM Nolvaliches November 5, 2011 – Present SEMINAR ATTENDED: Leadership Training Program CWTS – NSTP Feb. 12 – 13, 2011 CHARACTER REFFERENCE: Mrs. Aurora â€Å"Thet† Nolasco Assistant Restaurant Manager Jollibee SM Novaliches Mobile: 442-60-16 Mr. Harold Lucero, MIT Dean, Information Technology Department Colegio de Sta. Teresa de Avila Mobile: 09233689633 I hereby certify that the above information is true and correct to the best of my knowledge and belief. ____________________________ Applicant’s Signature Gernalin J. Iglesia 7198 Sto. Nino St. Maligaya Park Subd. Caloocan City Mobile: 09126792363 Email: gernz_08@yahoo.com EDUCATIONAL ATTAINMENT: Course Presently Enrolled In: Bachelor of Science in Information Technology Tertiary: Colegio de Sta. Teresa de Avila Foundation Inc. No. 6 Kingfisher St., Corner Skylark St., Zabarte Subd., Novaliches, Q.C. University of St. La Salle Bacolod Corner La Salle Street Bacolod City, Negros Occidental 2008-2009 Secondary:Dona Monsterrat Lopez Memorial High School Rizal St. Silay City, Negros Occidental 2004-2008 Primary:Adela Elementary School Sitio Adela Silay City, Negros Occidental 1998-2004 PERSONAL BACKGROUND: Age:21 Sex:Female Birth Date:August 11, 1991 Height:5’2 Weight:110 lbs. Civil Status:Single Citizenship:Filipino Language:Filipino, Hiligaynon and English WORK EXPERIENCE On The Job Training VS & F Frontline Services Inc. April 10-May 2, 2012 SEMINAR ATTENDED: Leadership Training Program CWTS – NSTP Feb. 12 – 13, 2011 CHARACTER REFFERENCE: Ms. Annie L. Salvador Manager, Accounting Department VS&F Frontline Services Inc. Mobile: 9374980 Mr. Harold Lucero, MIT Dean, Information Technology Department Colegio de Sta. Teresa de Avila Mobile: 09233689633 I hereby certify that the above information is true and correct to the best of my knowledge and belief. ____________________________ Applicant’s Signature Sarah Jane I. Jacob J, Zuniga Cmpd, Mahogany St., Silanganan Subd., Caloocan City Mobile: 09104802694 Email: jengfots@yahoo.com EDUCATIONAL ATTAINMENT: Course Presently Enrolled In: Bachelor of Science in Information Technology Tertiary: Colegio de Sta. Teresa de Avila Foundation Inc. #6 Kingfisher St., Corner Skylark St., Zabarte Subd., Novaliches, Q.C. Secondary:Novaliches High School T.S Cruz, Novaliches, Quezon City 2006-2010 Primary:Damong Maliit Elementary School San Antonio Subd., Novaliches, Quezon City 2000-2006 PERSONAL BACKGROUND: Age:18 Sex:Female Birth Date:December 23, 1993 Height:5’4 Weight:100 lbs. Civil Status:Single Citizenship:Filipino Language:Filipino and English WORK EXPERIENCE On The Job Training Land Registration Authorization May 14 – June 10 SEMINAR ATTENDED: Leadership Training Program CWTS – NSTP Feb. 12 – 13, 2011 CHARACTER REFFERENCE: Mrs. Imelda Teneza General Secretarial Land Registration Authorization Mr. Harold Lucero, MIT Dean, Information Technology Department Colegio de Sta. Teresa de Avila Mobile: 09233689633 I hereby certify that the above information is true and correct to the best of my knowledge and belief. ____________________________ Applicant’s Signature Daryl S. Llagas 379 camia St. malaria Rd. Caloocan City Mobile: 09169261853 Email: daryl.llagas08@gmail.com . EDUCATIONAL ATTAINMENT: Course Presently Enrolled In: Bachelor of Science in Information Technology Tertiary: Colegio de Sta. Teresa de Avila Foundation Inc. No. 6 Kingfisher St., Corner Skylark St., Zabarte Subd., Novaliches, Q.C. Secondary:Manuel luis Quezon High School. Malaria Caloocan City 2006-2010 Primary:Tabe Elementary School. Tabe Guiguinto Bulacan 2000-2006 PERSONAL BACKGROUND: Age:18 Sex:Male Birth Date:February 8, 1994 Height:5’7 Weight:140 lbs. Civil Status:Single Citizenship:Filipino Language:Filipino and English WORK EXPERIENCE On The Job Training Teletech Novaliches June 1 – August 30 SEMINAR ATTENDED: Leadership Training Program CWTS – NSTP Feb. 12 – 13, 2011 CHARACTER REFFERENCE: Mr. Rechor Quijano Business Communication Specialist Teletech Novaliches Mobile: 09328925781 Mr. Harold Lucero, MIT Dean, Information Technology Department Colegio de Sta. Teresa de Avila Mobile: 09233689633 I hereby certify that the above information is true and correct to the best of my knowledge and belief. ____________________________ Applicant’s Signature Zedrick Adrian C. Salunga Blk 15 Lot 13 Tulip Street Palmera Phase 1, Camarin, Caloocan City Mobile: 09303401304 Email: salunga.zedrick@gmail.com EDUCATIONAL ATTAINMENT: Course Presently Enrolled In: Bachelor of Science in Information Technology Tertiary: Colegio de Sta. Teresa de Avila Foundation Inc. No. 6 Kingfisher St., Corner Skylark St., Zabarte Subd., Novaliches, Q.C. Secondary:Mystical Rose School of Caloocan Inc. Ilang-Ilang Street, Almar Subdivision, Camarin, Caloocan City 2006-2010 Primary:Union Village Christian Academy Palmera Springs Phase V, Camarin, Caloocan City 2000-2006 PERSONAL BACKGROUND: Age:18 Sex:Male Birth Date:July 10, 1994 Height:5’2 Weight:98 lbs. Civil Status:Single Citizenship:Filipino Language:Filipino and English WORK EXPERIENCE On The Job Training Teletech Novaliches June 1 – August 30 SEMINAR ATTENDED: Leadership Training Program CWTS – NSTP Feb. 12 – 13, 2011 CHARACTER REFFERENCE: Mr. Rechor Quijano Business Communication Specialist Teletech Novaliches Mobile: 09328925781 Mr. Harold Lucero, MIT Dean, Information Technology Department Colegio de Sta. Teresa de Avila Mobile: 09233689633 I hereby certify that the above information is true and correct to the best of my knowledge and belief. ____________________________ Applicant’s Signature