Computers are not confined to being used for entertainment but ...

A. Introduction A library is a place in which in turn literary and artistic supplies such as catalogs, periodicals, magazines, pamphlets, styles, records, and tapes, happen to be kept for reading, research or financing. A collection of this kind of materials, particularly when systematically set up; a room of personal home for this sort of collection.

At first, your collection is a bunch of books using a librarian to evaluate them out to you, and back in as you return these people. Your librarian insures (of tries to, as money permits) your collection is very well stocked with current headings. The librarian also has to hold the building cool and in good repair and also these things only shows a number of the things that make up your collection.

Now a day, within a highly technical society, man productivity is done more efficient throughout the development of electronic gadgets. Now, while using advent of this kind of modernization in education, a great way to globalize the research is to comprehend that technology is improving at an extremely fast pace. At school, reading components are kept in libraries. Catalogue is a place in which ebooks and related materials happen to be kept to be used but not for sale.

It is also structured for use and maintained by a public physique, an organization or a exclusive individual. In addition , it is a put in place which we get information in just about any format and from a large number of sources. The librarian must keep the place neat in order that it is favorable for learning.

The librarian is also anybody who is accountable for monitoring all the books which might be borrowed and returned by the borrowers. N. Background from the Study The proponents will certainly propose the Library Catalogs Borrowing and Returning System for Standard Miguel Malvar Elementary School located at Mangga Ave, Sta Mesa, Manila.. The Head Librarian, Mrs. Barre?o Guerrero mentioned that they are at present using the Dewey Decimal Library System.

They are still employing a manual system. The collection users as well as the librarian continue to use greeting card catalogues in searching for studying materials and use index card to get the information of borrowed and came back books. The proponent’s study was precisely what is which come across to the Library by the end user, Librarian and exactly how the Owner or perhaps the Administrator from the said institution will provide a good service to all their clients to get a good responses. The study will focus on transaction which done inside the Library like funding, returning of books by simply students, performance and employees.

C. Affirmation of the Problem General Problem: * How you can computerized Library System of Style. Miguel Malvar Elementary School? Certain Problem: 5. How to maintain library records? * How to give back-up duplicate? * How to maintain data ethics? * Learning to make user friendly screen? * Tips on how to secure databases files?

D. Objective with the Study Standard Objective: * To develop a computerized catalogue system pertaining to Gen. Miguel Malvar Grammar school using Aesthetic Basic. Specific Objective: * To maintain catalogue record by providing add, edit and delete module to our system. * To create energy module to compliment database files. * To maintain data honesty by making a relational database files. 2. To make a user friendly screen by simply designing a straightforward screen that could be easily figure out. * To secure database document by setting up a user log-in for protection purposes.

Electronic. Scope and Limitations The library system can only keep an eye on the took out and delivered books. This computes the penalty for due date.

The machine does not include the inventory from the books. F. Significance in the Study Because the analysts identify their objectives, they were able to go over the significance of their topic to certain elements which they are closely related: Librarian / Custodian * The Librarian / Custodian will take advantage of this task because it can help him/her screen the books borrowed and returned. Institution * The college will reap the benefits of this project because they help give books to student of these school. Pupil * Students will take advantage of this task because will help the student to simply know if the books he /she require is available or not in the library.

Part II A. Feasibility Examine 1 . Operational Feasibility The device is operationally feasible because their selection staff is usually computer well written and is conditioned to use computer system applications additionally, they understand the basic things they i did so on the manual library system, thereby preserving the concepts of the originallibrary logic. We can also declare it is operationally feasible since their center has computer systems without acquiring much space and the key office in fact holds the database simply because they originally include a main storage area of information to get the payment of their college student. 2 . Technological Feasibility The proposed product is technicallyfeasible since the Software and Hardware can be obtained.

The Software being use is Visual Basic. Net and the repository is MS Access. three or more. Economical Feasibility The system is usually economically possible. The maintenance of computer hardware and software is up to date. a. Preliminary Investment Laptop set with printer P15, 000.

Computer system programmer P40, 000 Total initial Expenditure P55, 00 b. Existing Operational Cost Salary of three employees P30, 000 Logbook & documents P1, 500 Ball pensP150 Electricity S 1, 200 Total detailed cost P32, 850 c. Proposed Program Operational Expense Salary of two employees P25, 000 Net connectionP1, 2 hundred Electricity P1, 500 PapersP 900 Total operational expense P28, 600 d. Financial savings Monthly Detailed Cost| Existing| Supplies| P1, 650| Maintenance| P1, 200| Labor| P30, 000| Total| P32, 850| Yearly Detailed Cost| Existing| 1st| P394, 200| 2nd| P421, 794| 3rd| P449, 388| 4th| P476, 982| 5th| P504, 576| Month to month Operational Cost| Proposed|. Supplies| P900| Maintenance| P2, 700| Labor| P25, 000| Total| P28, 600| Yearly Functional Cost| Proposed| 1st| P343, 200| 2nd| P367, 224| 3rd| P391, 284| 4th| P415, 272| 5th| P439, 296| SAVINGS/PAY | Existing System| Recommended System| Savings| 1st Year| 394, 200| 343, 200| 51, 000| 2nd Year| 788, 400| 686, 400| 102, 000| 3rd Year| 1, 182, 600| you, 029, 600| 153, 00| 4th Year| 1, 576, 800| one particular, 372, 800| 204, 000| 5th Year| 1, 971, 000| 1, 716, 000| 255, 00| BACK PERIOD Chapter 3 ID ID A. Data Flow Diagram 1 . DFD of Existing System LENT BOOK BORROWED BOOK ZERO PENALTY NO PENALTY ACCCEPTED BORROWED BOOK ACCCEPTED BORROWED BOOK 5 CHECK PENALTY 5 EXAMINE.

PENALTY four ACCEPT TOOK OUT BOOK 4 ACCEPT LENT BOOK six RETURN ID 6 RETURNING ID Pupil Student IDENTITY, BOOK ID, BOOK one particular RECEIVED ID & BOOK 1 RECEIVED ID & BOOK M2 BOOK CREDIT CARD M2 PUBLICATION CARD M1 LOGBOOK M1 LOGBOOK W/ PENALTY W/ PENALTY RECEIPT RECEIPT RECEIVED ID & BOOK RECEIVED ID & BOOK SENT BOOK DISPATCHED BOOK a couple of UPDATE CARD BOOK 2 UPDATE CARD BOOK six ACCEPT REPAYMENT 7 ACKNOWLEDGE PAYMENT M2 BOOK CREDIT CARD M2 PUBLICATION CARD PAYMENT PAYMENT Student Student. three or more DISPATCH BOOK 3 DISPATCH BOOK M3 PENALTY M3 PENALTY 2 . DFD of Proposed Program ID IDENTIFICATION 5 RECORD RETURN TRANSACTION 5 RECORD RETURN DEAL NO PAYMENT NO REPAYMENT RETURNED PUBLICATION RETURNED PUBLICATION. 4 EXAMINE PENALTY 4 CHECK CHARGES Student College student BORROWED BOOK BORROWED BOOK Recorded Go back Transaction Recorded Return Purchase 1 RECORD BOOK CARD 1 RECORD BOOK CARDS C1 DEAL INFO C1 TRANSACTION FACTS C1 PURCHASE INFO C1 TRANSACTION INFORMATION DISPATCHED BOOK DISPATCHED BOOK Recorded Deal Recorded Deal 6 FIGURE OUT PENALTY 6th COMPUTE CHARGES C1 DEAL INFO C1 TRANSACTION FACTS 7 AGREE TO PENALTY several ACCEPT PENALTY COMPUTED PENALTY COMPUTED FEES 2 REVISE CARD BOOK 2 REVISE CARD PUBLICATION C2 Book Card C2 Book Cards PAYMENT REPAYMENT CHANGE ALTER Student College student 3 MAIL BOOK a few DISPATCH PUBLICATION B. Prototyping 1 . Plan Listing Display screen Title: Log-in Form Explanation: This is the log-in form.

Initially the user is going to input the username and the password then click the log-in button. In case the user put the correct account information it will show the transactions type. Screen Subject: ERROR Press button Description: This type will show in case the user inputted the wrong account information. To go back to the log-in form click the ALRIGHT button.

Administrator Screen Title: Administrator Description: This is where you can view the student accounts and admin account. In case you click the button menu you can observe the information with the student as well as the administration. Admin Account Display screen Title: Admin Account Information: This is where the consumer can look at their consideration and info. Student Accounts Screen Subject: Student Bank account Description: This is how the user can easily view their particular account and information. Select Information Screen Title: Select Information Information: This is the Select Information Kind.

If the customer wants to view the Student Details he/she is going to click the Scholar Information Key. If the consumer wants to see the Book Details he/she is going to click the Publication Information Switch. If the consumer wants to watch or generate Transaction he/she will click on the Transaction Info Button. If the user really wants to view the studies he/she is going to click the Statement Button. In the event the user desires to view or perhaps make one more user they will click on the Administration Switch.

Student Info Screen Name: Student Information Description: This form is the Scholar Information type. It contains the Student No ., Identity, Grade and Section, Addresses, and Contact information. In this form the user can also add, edit and delete Scholar information. Book Information Display Title: Publication Information Description: This form is definitely the Book Info form.

It contains the Book No ., Book Title, Book ISD, Publication Author, Subject matter, Location and Status. With this form the customer can add, change and erase Book Data. Transaction Details of Borrowed Book Display Title: Transaction Information of Borrowed Book Description: This type is the Deal Information of Borrowed Publication form. The person can type the Publication No ., Deadline and fees of the Took out Book.

Purchase Information of Returned publication Screen Name: Transaction Info of Returned Book Description: This form is a Transaction Information of Went back Book form. This form will compute the Penalty based on the due date or how much time it was prior to book is usually returned.

Data source File Structures. | Scholar Information| | Field Name| Type| Width| Student No| Number| 15| Name| Text| 50| Quality & Section| Text| 50| Address| Text| 150| Speak to No| Number| 15| | Book Information| | Discipline Name| Type| Width| Publication No| Number| 10| Publication Title| Text| 150| Book Author| Text| 150| Subject| Text| 100| Location| Text| 150| Status| Text| 150| | DEAL INFO| | Field Name| Type| Width| Transaction No| Number| 15| Student No| Number| 15| Name| Text| 150| Publication No| Number| 10| Publication Author| Text| 150| Date Borrow| Date| N/A| Time Return| Date| N/A| Thanks 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| Particular date return| Date| N/A| Time Due| Date| N/A| General Miguel Malvar Elementary School Mangga Ave, Sta Mesa, Manila Report of Transaction Purchase No| Student No| Publication No| Book Title| Day Borrow| Because of Date| Day Returned| Penalty| 1| 1000013| 400| Abilities 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 language V| 10/1/2012| 10/9/2012| 10/9/2012| Php50. 00| | Total: ____P100. 00____ Total: ____P100. 00____ | | | | | | | | | | | | | | | | | | | Prepared By: __Tina Guerrero__ Made by: __Tina Guerrero__ General Miguel Malvar Grammar school Mangga Ave, Sta Direccion, Manila Record of Took out Books Deal No| Student No| Book No| Publication Title| Date Borrow| Because of 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__ Made by: __Tina Guerrero__ General Miguel Malvar Grammar school Mangga Volatil, Sta Comensales, Manila Statement of Retuned Books Purchase No| Scholar No| Publication No| Book Title| Time Borrow| Credited Date| Time Returned| 1| 1000013| 400| Skills in Reading| 10/2/2012| 10/5/2012| 10/8/2012| 2| 1000014| 401| Modern day 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__ Consumer Manual I actually.

System Requirements CPU| Pentium 4, Athlon XP, Semprov| | Clock Speed| 2 . 0GHz or perhaps higher| | System Memory(RAM)| 1G| | Operating System| Windows XPVista| |. HDD free space| 2 . 0GB| | DirectX| 9. zero or higher| | Internet Connection| 1Gbps| | Video Card| GeForce FX6600 or perhaps Radeon 9800 series| | Video Memory| 512MB| | II. Set up 1 . Operate the unit installation setup, MMESLYS-Setup. exe. Soon after, users are to be prompted to this screen.

Simply click Next to stay. Welcome to Miguel Malvar Elem School Library System Installation Setup Wizard Everyone should be open to Miguel Malvar Elem School Selection System Set up Setup Sorcerer This will mount Miguel Malvar Elem School Library Program 1 . zero on your Computer This will install Miguel Malvar Elem School Collection System 1 . 0 on your computer system 2 . They shall be asked to confirm if you agree with the End-User license contract for them to be able to proceed while using installation. Choose I agree then Next button can be enabled.

Simply click Next. 3. After affixing your signature to off the EULA, they would now be brought to the page where they would select where to position the folder intended for the application. Select where to position the files and click Subsequent. 4. The wizard will start setting up the system. Just wait for the improvement to reach completion and then just click Next.

The installation has been successfully accomplished by that and the user only needs to click Close to exit the unit installation wizard. III. System Routing 1 . This is the log-in kind will be everyone should be open to the sign in interface. They will just need to utilize the log in IDs provided by the Administrator and after that click the Log in button. installment payments on your This is the unacceptable username username and password if your username you insight is not correct, just click the okay button.

3. This is where you will see the student accounts and admin account. If you click the button menu you can observe the information from the student plus the administration. 5. This admin account will show the information of admin and their account a few. This student account displays the information from the student. six.

This is the Select Information Kind. If the customer wants to view the Student Info he/she will certainly click the Student Information Key. If the user wants to view the Book Data he/she is going to click the Book Information Key. If the end user wants to watch or help to make Transaction he/she will click on the Transaction Info Button. In case the user wants to view the information he/she can click the Record Button.

In the event the user desires to view or perhaps make one other user they will click the Administration Button. 7. This type is the College student Information form. It contains the Student No ., Brand, Grade and Section, Talk about, and Contact number. In this constitute the user can also add, edit and delete College student information. almost eight. This form is the Book Data form.

It contains the Book No ., Publication Title, Publication ISD, Book Author, Subject, Location and Status. In this form the user can add, modify and delete Book Data. 9. This type is the Purchase Information of Borrowed Publication form.

The person can insight the Book No ., Deadline and charges of the Took out Book. twelve. This form is definitely the Transaction Data of Returned Book form. This form will compute the Penalty depending on the due date or the length of time it was before the book is usually returned.