Computers are not confined to being used for entertainment but its role in education is also vast Essay

A. Introduction A library is a shopping centre in which literary and artistic materials much(prenominal) as books, periodicals, newspapers, pamphlets, prints, records, and tapes, argon kept for reading, reference or lending. A collection of such materials, especially when trunkatically arranged a room of private home for such collection. At first glance, your library is a bunch of books with a librarian to check them out to you, and back in when you return them. Your librarian insures (of tries to, as bullion permits) your library is well stocked with current titles.The librarian likewise has to keep the building neat and in good repair and also these things only shows a few of the things which restrain up your library. Now a day, in a highly technological society, human productivity is made more efficient through with(predicate) the development of electronic gadgets. Now, with the advent of such modernization in education, one way to globalize the process of research is to re alize that technology is advancing at an incredibly fast pace.In check, reading materials are stored in libraries. Library is a place in which books and related materials are kept for office further not for sale. It is also organized for use and maintained by a public body, an institution or a private individual. In addition, it is a place in which we get in bounceation in any unionizeat and from many sources. The librarian has to keep the room neat so that it is conducive for learning. The librarian is also the person who is liable for observeing all the books that are borrowed and returned by the borrowers.B. Background of the Study The proponents bequeath propose the Library bears Borrowing and Returning scheme for global Miguel Malvar Elementary School located at Mangga Ave, Sta Mesa, manilla paper. . The Head Librarian, Mrs. Tina Guerrero stated that they are currently development the Dewey Decimal Library System. They are still utilizing a manual(a) system. The li brary substance abusers and the librarian still use card catalogues in searching for reading materials and use index card for the records of borrowed and returned books.The proponents study was what is which bump to the Library by the user, Librarian and how the Owner or the Administrator of the said school entrust provide a good service to their clients to have a good feedback. The study will focus on transaction which done inside the Library like borrowing, returning of books by students, faculties and staffs. C. Statement of the Problem oecumenical Problem * How to computerized Library System of Gen. Miguel Malvar Elementary School? Specific Problem * How to maintain library records? * How to provide back-up copy?* How to maintain data integrity? * How to make user friendly screen? * How to secure database files? D. Objective of the Study General Objective * To develop a computerized library system for Gen. Miguel Malvar Elementary School using Visual Basic. Specific Objectiv e * To maintain library record by providing add, edit and blue-pencil module to our system. * To create utility module to back up database files. * To maintain data integrity by creating a relational database files. * To make a user friendly screen by designing a unsophisticated screen that plunder be easily understand.* To secure database file by creating a user log-in for security purposes. E. Scope and Limitations The library system can only monitor the borrowed and returned books. It computes the punishment for due date. The system does not include the inventory of the books. F. Significance of the Study As the researchers identify their objectives, they were able to discuss the importation of their topic to certain factors which they are closely related Librarian / Custodian * The Librarian / Custodian will benefit from this project because it will serving him/her monitor the books borrowed and returned.School * The school will benefit from this project because they help p rovide books to student of that school. pupil * The student will benefit from this project because can help the student to easily know if the books he /she need is available or not in the library. Chapter II A. Feasibility Study 1. Operational Feasibility The system is operationally feasible because their library staff is computer literate and is trained to use computer applications plus, they know the basic things they used to do on the manual library system, thereby maintaining the concepts of the originallibrary logic.We can also say that it is operationally feasible because their facility has computers without taking much billet and the main office actually holds the database since they primitively have a main storage of information for the billing of their student. 2. Technical Feasibility The proposed system is technicallyfeasible because the Software and Hardware are available. The Software to be use is Visual Basic. Net and the database is MS Access. 3. Economical Feasibi lity The system is economically feasible. The maintenance of computer hardware and software is updated. a. Initial Investment Computer entrap with printer P15, 000.Computer programmer P40, 000 sum total initial Investment P55, 00 b. Existing Operational Cost Salary of 3 employees P30, 000 recordbook & papers P1, 500 Ball pensP150 electricity P 1, 200 Total operational cost P32,850 c. Proposed System Operational Cost Salary of 2 employees P25, 000 Internet connectionP1, 200 Electricity P1, 500 PapersP 900 Total operational cost P28,600 d. Savings Monthly Operational Cost Existing Supplies P1,650 Maintenance P1,200 Labor P30,000 Total P32,850 coursely Operational Cost Existing beginning(a) P394,200 second P421,794 3rd P449,388 4th P476,982 5th P504,576 Monthly Operational Cost Proposed.Supplies P900 Maintenance P2,700 Labor P25,000 Total P28,600 Yearly Operational Cost Proposed 1st P343,200 2nd P367,224 3rd P391,284 4th P415,272 5th P439,296 SAVINGS/PAY Existing System Proposed System Savings 1st Year 394,200 343,200 51,000 2nd Year 788,400 686,400 102,000 3rd Year 1,182,600 1,029,600 153,00 4th Year 1,576,800 1,372,800 204,000 5th Year 1,971,000 1,716,000 255,00 BACK PERIOD Chapter III ID ID A. Data Flow Diagram 1. DFD of Existing System BORROWED leger BORROWED sustain NO penalisation NO PENALTY ACCCEPTED BORROWED BOOK ACCCEPTED BORROWED BOOK 5 CHECK PENALTY 5 CHECK.PENALTY 4 demand BORROWED BOOK 4 ACCEPT BORROWED BOOK 6 RETURN ID 6 RETURN ID Student Student ID, BOOK ID, BOOK 1 RECEIVED ID & BOOK 1 RECEIVED ID & BOOK M2 BOOK CARD M2 BOOK CARD M1 LOGBOOK M1 LOGBOOK W/ PENALTY W/ PENALTY RECEIPT RECEIPT RECEIVED ID & BOOK RECEIVED ID & BOOK loadingED BOOK DISPATCHED BOOK 2 UPDATE CARD BOOK 2 UPDATE CARD BOOK 7 ACCEPT earnings 7 ACCEPT PAYMENT M2 BOOK CARD M2 BOOK CARD PAYMENT PAYMENT Student Student.3 DISPATCH BOOK 3 DISPATCH BOOK M3 PENALTY M3 PENALTY 2. DFD of Proposed System ID ID 5 RECORD RETURN dealing 5 RECORD RETURN TRANSACTION NO PAYMENT NO P AYMENT RETURNED BOOK RETURNED BOOK.4 CHECK PENALTY 4 CHECK PENALTY Student Student BORROWED BOOK BORROWED BOOK Recorded Return act Recorded Return relations 1 RECORD BOOK CARD 1 RECORD BOOK CARD C1 TRANSACTION info C1 TRANSACTION INFO C1 TRANSACTION INFO C1 TRANSACTION INFO DISPATCHED BOOK DISPATCHED BOOK Recorded Transaction Recorded Transaction 6 COMPUTE PENALTY 6 COMPUTE PENALTY C1 TRANSACTION INFO C1 TRANSACTION INFO 7 ACCEPT PENALTY 7 ACCEPT PENALTY COMPUTED PENALTY COMPUTED PENALTY 2 UPDATE CARD BOOK 2 UPDATE CARD BOOK C2 concord Card C2 criminal record Card PAYMENT PAYMENT CHANGE CHANGE Student Student 3 DISPATCH BOOK 3 DISPATCH BOOK B. Prototyping 1.Program Listing pervade patronage Log-in Form Description This is the log-in form. First the user will input the username and the password then crack the log-in button. If the user inputted the correct username and password it will show the transactions form. Screen claim ERROR get-up-and-go Description This form will sh ow if the user inputted the wrong username and password. To go back to the log-in form dog the OK button. Administrator Screen Title Administrator Description This is where you can view the student account and admin account. If you click the button posting you can see the information of the student and the administration.Admin Account Screen Title Admin Account Description This is where the user can view their account and information. Student Account Screen Title Student Account Description This is where the user can view their account and information. submit cultivation Screen Title Select info Description This is the Select Information Form. If the user wants to view the Student Information he/she will click the Student Information Button. If the user wants to view the Book Information he/she will click the Book Information Button. If the user wants to view or make Transaction he/she will click the Transaction Information Button.If the user wants to view the reports he/she wi ll click the Report Button. If the user wants to view or make another user he/she will click the disposition Button. Student Information Screen Title Student Information Description This form is the Student Information form. It contains the Student No., trace, Grade and Section, Address, and Contact form. In this form the user can add, edit and delete Student information. Book Information Screen Title Book Information Description This form is the Book Information form. It contains the Book No. , Book Title, Book ISD, Book Author, Subject, Location and posture.In this form the user can add, edit and delete Book Information. Transaction Information of Borrowed Book Screen Title Transaction Information of Borrowed Book Description This form is the Transaction Information of Borrowed Book form. The user can input the Book No. , Due fancy and penalty of the Borrowed Book. Transaction Information of Returned book Screen Title Transaction Information of Returned Book Description This form is the Transaction Information of Returned Book form. This form will compute the Penalty based on the due date or how long it was before the book is returned. Database File Structures. Student Information Field Name Type Width Student No amount 15 Name text edition 50 Grade & Section Text 50 Address Text 150 Contact No Number 15 Book Information Field Name Type Width Book No Number 10 Book Title Text 150 Book Author Text 150 Subject Text 100 Location Text 150 Status Text 150 TRANSACTION INFO Field Name Type Width Transaction No Number 15 Student No Number 15 Name Text 150 Book No Number 10 Book Author Text 150 construe Borrow Date N/A Date Return Date N/A Due Date Date N/A Penalty Currency 10 Book Card .Field Name Type Width Name Text 150 Title of the book Text 15 Book number Text 10 Date Borrow Date N/A Date return Date N/A Date Due Date N/A General Miguel Malvar Elementary School Mangga Ave, Sta Mesa, Manila Report of Transaction Transaction No Student No Book No Bo ok Title Date Borrow Due Date Date Returned Penalty 1 1000013 400 Skills in Reading 10/2/2012 10/5/2012 10/8/2012 Php30. 00 2 1000014 401 Modern in Action 10/3/2012 10/5/2012 10/8/2012 Php20. 00 3 1000015 402 English V 10/1/2012 10/9/2012 10/9/2012 Php50. 00 Total ____P100. 00____ Total ____P100. 00____ Prepared By __Tina Guerrero__ Prepared By __Tina Guerrero__ General Miguel Malvar Elementary School Mangga Ave, Sta Mesa, Manila Report of Borrowed Books Transaction No Student No Book No Book Title Date Borrow Due Date 1 1000013 400 Skills in Reading 10/2/2012 10/5/2012 2 1000014 401 Modern in Action 10/3/2012 10/5/2012 3 1000015 402 English V 10/1/2012 10/9/2012 Prepared By __Tina Guerrero__ Prepared By __Tina Guerrero__General Miguel Malvar Elementary School Mangga Ave, Sta Mesa, Manila Report of Retuned Books Transaction No Student No Book No Book Title Date Borrow Due Date Date Returned 1 1000013 400 Skills in Reading 10/2/2012 10/5/2012 10/8/2012 2 1000014 40 1 Modern in Action 10/3/2012 10/5/2012 10/8/2012 3 1000015 402 English V 10/1/2012 10/9/2012 10/9/2012 Prepared By __Tina Guerrero__ Prepared By __Tina Guerrero__ User Manual I. System Requirements CPU Pentium 4, Athlon XP, Semprov Clock Speed 2. 0GHz or higher System Memory(RAM) 1G Operating System Windows XPVista .HDD free space 2. 0GB DirectX 9. 0 or higher Internet Connection 1Gbps Video Card GeForce FX6600 or Radeon 9800 series Video Memory 512MB II. innovation 1. Run the installation setup, MMESLYS-Setup. exe. Afterwards, users are to be prompted to this screen. Click Next to continue. Welcome to Miguel Malvar Elem School Library System Installation Setup Wizard Welcome to Miguel Malvar Elem School Library System Installation Setup Wizard This will install Miguel Malvar Elem School Library System 1. 0 on your Computer This will install Miguel Malvar Elem School Library System 1. 0 on your Computer 2.They will be asked to confirm if you agree on the End-User license ag reement for them to be able to proceed with the installation. Choose I agree then Next button would be enabled. Click Next. 3. After signing off the EULA, they would now be brought to the page wherein they would choose where to put the cusp for the application. Choose where to put the files and click Next. 4. The wizard will now start installing the system. Just wait for the progress to reach completion and then click Next. The installation has been successfully completed by that and the user just needs to click Close to exit the installation wizard.III. System Navigation 1. This is the log-in form will be welcome to the log in interface. They just need to use the log in IDs provided by the Administrator and then click the Log in button. 2. This is the invalid username password if your username you input is not correct, just click the ok button. 3. This is where you can view the student account and admin account. If you click the button menu you can see the information of the stude nt and the administration. 4. This admin account will show the information of admin and their account 5. This student account will show the information of the student. 6.This is the Select Information Form. If the user wants to view the Student Information he/she will click the Student Information Button. If the user wants to view the Book Information he/she will click the Book Information Button. If the user wants to view or make Transaction he/she will click the Transaction Information Button. If the user wants to view the reports he/she will click the Report Button. If the user wants to view or make another user he/she will click the Administration Button. 7. This form is the Student Information form. It contains the Student No. , Name, Grade and Section, Address, and Contact number.In this form the user can add, edit and delete Student information. 8. This form is the Book Information form. It contains the Book No. , Book Title, Book ISD, Book Author, Subject, Location and Statu s. In this form the user can add, edit and delete Book Information. 9. This form is the Transaction Information of Borrowed Book form. The user can input the Book No. , Due Date and penalty of the Borrowed Book. 10. This form is the Transaction Information of Returned Book form. This form will compute the Penalty based on the due date or how long it was before the book is returned.